A MySQL database server contains many databases (or schemas). Each database consists of one or more tables. A table is made up of columns (or fields) and rows (records).
Who introduced MySQL:
MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael “Monty” Widenius. Original development of MySQL by Widenius and Axmark began in 1994. The first version of MySQL appeared on 23 May 1995.
Original owner: MySQL AB – former software company that was founded in 1995.
Current owner: Oracle Corporation – multinational computer Technology Corporation headquartered in Redwood City, California, United States.
The name MySQL owes its name to Monty’s daughter ‘My’. Indeed Michael, often called Monty, has a habit of naming his projects after his children: MariaDB was named after his youngest daughter and MaxDB was named after his son Max.
- The MySQL™ software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server.
- MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
- MySQL is a trademark of Oracle Corporation and/or its affiliates, and shall not be used by Customer without Oracle’s express written authorization.
Link to download MySQL: https://dev.mysql.com/downloads/
MySQL is a leading open source database management system. It is a multi-user, multithreaded database management system. MySQL is especially popular on the web. It is one of the parts of the very popular LAMP platform. Linux, Apache, MySQL and PHP. MySQL database is available on most important OS platforms. It runs on BSD Unix, Linux, Windows or Mac. Wikipedia, YouTube, Facebook use MySQL. These sites manage millions of queries each day. MySQL comes in two versions: MySQL server system and MySQL embedded system. The MySQL server software and the client libraries are dual-licensed: GPL version 2 and proprietary license.
The development of MySQL began in 1994 by a Swedish company MySQL AB. Sun Microsystems acquired MySQL AB in 2008. Sun was bought by Oracle in 2010.
MySQL, PostgreSQL, Firebird, SQLite, Derby, and HSQLDB are the most well-known open source database systems.
MySQL is developed in C/C++. Except for C/C++, APIs exist for PHP, Python, Java, C#, Eiffel, Ruby, Tcl or Perl.
Key MySQL features:
The important properties of MySQL are Relational Database System, Client/Server Architecture, SQL compatibility, SubSELECTs, Views, Stored procedures, Triggers, Unicode, User interface, Full-text search, Replication, Transactions, Foreign key constraints, GIS functions, Programming languages, ODBC, Platform independence, Speed.
Versions of MySQL:
- First internal release on 23 May 1995
- Version 3.19: End of 1996
- Version 3.20: January 1997
- Windows version was released on 8 January 1998 for Windows 95 and NT
- Version 3.21: production release 1998, from www.mysql.com
- Version 3.22: alpha, beta from 1998
- Version 3.23: beta from June 2000, production release 22 January 2001.
- Version 4.0: beta from August 2002, production release March 2003
- Version 4.01: beta from August 2003,
- Version 4.1: beta from June 2004,
- Version 5.0: beta from March 2005, production release October 2005 (cursors, stored procedures, triggers, views, XA transactions).
- Sun Microsystems acquired MySQL AB in 2008.
- Version 5.1: production release 27 November 2008 (event scheduler, partitioning, plugin API, row-based replication, server log tables)
- Oracle acquired Sun Microsystems on 27 January 2010.
- MySQL Server 5.5 was generally available (as of December 2010).
- MySQL Server 6.0.11-alpha was announced on 22 May 2009 as the last release of the 6.0 line. Features developed for 6.0 are being incorporated into future releases.
- The general availability of MySQL 5.6 was announced in February 2013.
- The general availability of MySQL 5.7 was announced in October 2015.As of MySQL 5.7.8, August 2015
- MySQL Server 8.0 was announced in April 2018.
Similarities between SQL and MySQL:
SQL stands for Structured Query Language and MySQL is a database management system, like SQL Server, Oracle, Informix, Postgres, etc. SQL server is owned by Microsoft and is typically referred as Microsoft SQL Server. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. Both are considered as a choice of utility for data management. Both are efficient at keeping your data organized and readily available through a user interface. Both Includes the concept of the schema (that is table storage) for data storage. Both SQL server and MySQL have the support from their respective vendors both in free and paid form.
MySQL vs SQL server:
The following are the differences between MySQL and SQL server.
|MySQL is available for free since MySQL is an open source.||SQL Server is not an open source and payment has to be made to use SQL Server|
|MySQL offers only updateable views.||SQL Server offers indexed views which are much more powerful, performance wise.|
|MySQL does not support XML.||SQL Server supports XML|
|MySQL provides only table level security.||SQL Server provides column level security.|
|MySQL does not offer any certification for security||SQL Server has C2 compliant certification. Database security is verified by third party|
|Earlier versions of MySQL do not support triggers. Only MySQL 5.0 supports triggers.||SQL Server provides triggers.|
|User defined functions are not supported in MySQL.||User defined functions are supported in SQL Server.|
|Cursor feature is not available in MySQL||Cursor feature is available in SQL Server.|
|Stored procedures and full join facility is not offered in MySQL||Stored procedures and full join facility are offered in SQL Server.|
|Import and Export functions have very limited support in MySQL.||Import and export are extensively supported in MySQL|
|Transaction support is very much limited in MySQL||Transaction support is extensively and fully offered in SQL Server.|
|Replication support is very much limited in MySQL||Replication support is extensively and fully offered in SQL Server|
|Online backup support and clustering support is limited in MySQL.||Online backup support and clustering support is extensive and complete in SQL Server.|
|OLAP Services, Data Reporting and Data Mining are not supported in MySQL.||OLAP Services, Data Reporting and Data Mining are supported in SQL Server.|