MySQL is probably the most popular database management system for web servers. Developed in the mid 1990s, it’s now a mature technology that powers many of today’s most-visited Internet destinations.
A database is a structured collection of records or data stored in a computer system and organized in such a way that it can be quickly searched and information can be rapidly retrieved.
The SQL in MySQL stands for Structured Query Language. This language is loosely based on English and is also used on other databases such as Oracle and Microsoft SQL Server. It is designed to allow simple requests from a database via commands such as:
SELECT title FROM publications WHERE author = 'Charles Dickens';
MySQL is the database construct that enables PHP and Apache to work together to access and display data in a readable format to a browser. It is a Structured Query Language server designed for heavy loads and processing of complex queries. As a relational database system, MySQL allows many different tables to be joined together for maximum efficiency and speed.
There is many features of My Sql :
- It is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
- It uses a standard form of the well-known SQL data language.
- It is released under an open-source license.
- It works on many operating systems and with many languages.
- It works very quickly and works well even with large data sets.
- PHP ships with a number of functions designed to support MySQL databases.