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. And to extract data from the tables queries are used.
| 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[1] |
| 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.[2] 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:
Many PHP scripts also use MySQL. These include:
MySQL Media
David Axmark (left) and Michael "Monty" Widenius, founders of MySQL AB, in 2003
Geir Høydalsvik, current Senior Software Development Director for MySQL at Oracle in 2018
MySQL Workbench running on macOS
Related pages
Notes
- ↑ "Changes in MySQL 5.7.15". MySQL 5.7 Reference Manual. Oracle. 2016-09-06. Retrieved 16 September 2016.
- ↑ "What is MySQL? | Data Basecamp". 2022-03-08. Retrieved 2022-06-20.
- ↑ Apple's Xserve uses MySQL