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.

We see you’re using an ad blocker.

Our website is made possible by displaying ads to our visitors.

Please help us continue to provide you with free. So please disabling your ad blocker.