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).
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.