MySQL Introduction
MySQL tutorial provides basic and advanced concepts of MySQL, It is open-source and free. MySQL is one of the best RDBMS (Relational DataBase Management System) being used for developing various web-based software applications. MySQL was developed by Michael Widenius and David Axmark in 1994. Presently MySQL is maintained by Oracle (formerly Sun, formerly MySQL AB)., this is a Swedish company.

What is a Database?

MySQL is a fast, easy to use relational database, it is Initial release date is 23 May 1995.  MySQL is  commonly used in PHP scripts to create powerful and dynamic server-side applications. These database is a separate application that stores a collection of data. Each database has one or more distinct APIs for creating, accessing, managing, searching and replicating the data it holds.

Before You Begin

You should have a basic knowledge of the HTML and PHP tutorials.

MySQL supported platforms

  • Linux (RedHat, SUSE, Mandrake, Debian)
  • Embedded Linux (MontaVista, LynuxWorks BlueCat)
  • Unix (Solaris, HP-UX, AIX)
  • BSD (Mac OS X, FreeBSD)
  • Windows (Windows 2000, Windows NT)
  • RTOS (QNX)

MySQL supported Languages
C Language, C++ , C# , Java, Delphi, Python, PHP, Perl, Visual Basic.

A Relational DataBase Management System (RDBMS) is a software that :

  • Enables you to implement a database with tables, columns and indexes.
  • Guarantees the Referential Integrity between rows of various tables.
  • Updates the indexes automatically.
  • Interprets an SQL query and combines information from various tables.

MySQL is becoming so popular because of these following good reasons :

MySQL is an open-source database , So  this is free of cost you have nothing to pay a single rupee.
MySQL is a very powerful program. It handles a large subset of the functionality of the most expensive and powerful database packages.
MySQL is very friendly to PHP, the most popular language for web development.
MySQL uses a standard form of the well-known SQL data language.
MySQL supports on many operating systems and with many languages like PHP, PERL, C, C++, JAVA, etc.
MySQL works very quickly and works well even with large data sets.
MySQL is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.
MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).

MySQL Features

Easy to use : MySQL is easy to use. You have to get only the basic knowledge of SQL. You can build and interact with MySQL with only a few simple SQL statements.
It is secure : MySQL consist of a solid data security layer that protects sensitive data from intruders. Passwords are encrypted in MySQL.
Client/ Server Architecture : MySQL follows a client /server architecture. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server; that is, they query data, save changes, etc.
Allows roll-back : MySQL allows transactions to be rolled back, commit and crash recovery.
High Performance : MySQL is faster, more reliable and cheaper because of its unique storage engine architecture.
High Flexibility : MySQL supports a large number of embedded applications which makes MySQL very flexible.
High Productivity : MySQL uses Triggers, Stored procedures and views which allows the developer to give a higher productivity.
It is scalable : MySQL can handle almost any amount of data, up to as much as 50 million rows or more. The default file size limit is about 4 GB. However, you can increase this number to a theoretical limit of 8 TB of data.
Strict mode : Ensures MySQL does not truncate or otherwise modify data to conform to an underlying data type when an incompatible value is inserted into that type.
Storage : Multiple storage engines, allowing one to choose the one that is most effective for each table in the application.