Introduction to MySql | What is MySQL

MySQL is an open-source relational database management system. It is a cross-platform, means it runs on a number of different operating systems such as Unix, Linux, Windows and Mac OS etc. MySQL is a fast, reliable, flexible and easy-to-use Relational Database Management System, which is being used for many small and big businesses. Some of the most popular websites like Wikipedia, YouTube, Facebook, Flickr, Google uses MySQL. And also Content Management Systems like WordPress, Drupal, Joomla, phpBB etc uses MySQL. MySQL operates using client/server architecture in which the server runs on the machine containing the databases and clients connect to the server over a network.

MySQL was developed by Michael Widenius and David Axmark in 1994 and marketed and supported by a Swedish company MySQL AB. Since after acquisition of MySQL AB, it is developed, distributed, and supported by Oracle Corporation. MySQL is written in C and C++.

The MySQL API available for many languages like PHP, Python, Java, C#, Eiffel, Ruby, Tcl or Perl. In these MySQL tutorial series we are going to use php to manipulate MySQL database.

Some of the main Characteristics of MySQL is as follows :

1. MySQL uses a standard form of the well-known SQL (Structured Query Language) language.

2. The GPL open-source license of MySQL allows users to modify the MySQL software to fit their own specific environments.

3. MySQL server works in client/server architecture.

4. MySQL works on many different operating systems such as Unix, Linux, Windows and Mac OS etc.

5. MySQL is multi-user and fully multi-threaded by using kernel threads. It can use multiple CPUs if they are available.

6. MySQL works very quickly and works well even with large data sets.

7. It supports up to 50 million rows or more in a table. The default file size limit for a table is 4GB.