MySQL

MySQL is a database system used by many websites on the Internet. It is based on SQL. Many ways of doing things in SQL are similar in MySQL. The data is structured in tables in MySQL. To extract data from the tables, queries are used.

MySQL

Developer(s)	MySQL AB, a subsidiary of Sun Microsystems since February 2008 which is also a subsidiary of Oracle Corporation since January 2010
Initial release	23 May 1995
Stable release	5.7.15 / September 6, 2016 (2016-09-06)
Repository	github.com/mysql/mysql-server
Written in	C, C++
Operating system	Cross-platform
Available in	English
Type	Relational database management system
License	GNU General Public License or proprietary EULA
Website	www.mysql.com

For example:

SELECT id_number

FROM main_database

WHERE name='John'

This query will return the 'id_number' of the person named 'John' from the table named 'main_database'.

History

MySQL was first released in May 1995 and a Windows version was released in January 1998. The latest version (5.6.11) was released in April 2013.

Compatibility

MySQL is compatible with many major programming languages. The most common one is PHP. An ODBC interface (called MyODBC) has been made so that users of Microsoft's ASP language can use MySQL.

Major users

Some of the largest MySQL users on the internet include:

• Apple
• Amazon.com
• Digg
• Google

Many PHP scripts also use MySQL. These include:

• WordPress
• phpBB
• MediaWiki - the software behind Wikipedia

Related pages

• PHP