MySQL, the most popular Open
Source SQL database management system, is developed, distributed, and supported
by Oracle Corporation.
Properties of MYSQL:
- MySQL
is a database management system used on the web.
- MySQL databases are relational.
- MySQL
is a database system that runs on a server
- MySQL
is ideal for both small and large applications
- MySQL
is very fast, reliable, scalable and easy to use
- MySQL
uses standard SQL
- MySQL
compiles on a number of platforms
- MySQL
is free to download and use.
- MySQL
is Open
Source.
- MySQL Server works in client/server or
embedded systems.
- MySQL
is developed, distributed, and supported by Oracle Corporation
- MySQL
is named after co-founder Monty Widenius's daughter: My
So MySQL
is an open source relational database management system (RDBMS) based on Structured Query Language (SQL).
Before You
have to understand that what is MySQL, first you need to understand database
and SQL.
Introduction to database
Everyday
we all of us are dealing with the data in our life in various ways.
Suppose you want to listen to your favorite songs, you
open your playlist from your smartphone or from computer using internet. In
this case, the playlist is a database.
When you take a photo and upload it to your account on a
social network like Facebook, In this case your photo gallery is a database.
When you browse an e-commerce website to buy shoes,
clothes, etc., their you use the shopping cart database.
So Databases are everywhere.
So what is a database?
By definition, a database is a structured collection of
data.
The data relate to each other by nature, e.g., a product
belonged to a product category and associated with multiple tags. Therefore, we
use the term relational database.
In the relational database, we model data like products,
categories, tags, etc., using tables. A table contains columns and rows. It is
like a spreadsheet.
A table may relate to another table using a relationship,
e.g., one-to-one and one-to-many relationships.
Because we deal with a significant amount of data, we
need a way to define the databases, tables, etc., and process data more efficiently.
Besides, we want to turn the data into information.
SQL
– the language of database
SQL stands for structured query language.
SQL is the standardized language used to access the
database.
ANSI/SQL defines the SQL
standard. The current version of SQL is SQL:2003. Whenever we refer to the SQL
standard, we mean the current SQL version.
SQL contains three parts:
1.
Data
definition language includes statements that help you define the database and
its objects, e.g., tables, views, triggers, stored procedures, etc.
2.
Data
manipulation language contains statements that allow you to update and query data.
3.
Data
control language allows you to grant
the permissions to a user to access specific data in the
database.
What is MySQL
My is the daughter’s name of the MySQL’s
co-founder, Monty Widenius.
The name of MySQL is the combination of My and SQL,
MySQL.
MySQL is a database management system that allows you to
manage relational databases. It is open source software backed by Oracle. It
means you can use MySQL without paying a dime. Also, if you want, you can
change its source code to suit your needs.
Even though MySQL is open source software, you can buy a
commercial license version from Oracle to get a premium support services.
MySQL is pretty easy to master in comparison with other
database software like Oracle Database, or Microsoft SQL Server.
MySQL can run on various platforms UNIX, Linux, Windows,
etc. You can install it on a server or even in a desktop. Besides, MySQL is
reliable, scalable, and fast.
Download
MySQL Database
If you don't have a PHP server with a MySQL
Database, you can download it for free here: http://www.mysql.com
.