What is MYSQL

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

.