MySQL is a free relational database management system. MySQL is developed and supported by Oracle Corporation, which acquired the trademark rights in conjunction with the acquired Sun Microsystems, which previously acquired the Swedish company MySQL AB.
Structured Query Language (SQL) is a standard high-level language for describing and manipulating data in database management systems (DBMS) based on a relational data model
MySQL is suitable for small to medium applications. It is included in the WAMP, AppServ, LAMP servers and in the portable server assemblies Denver, XAMPP, VertrigoServ. Usually MySQL is used as a server to which local or remote clients connect, but MySQL includes an internal server library that allows MySQL to be plugged into standalone programs.
The flexibility of MySQL is provided by a large number of table types: users can select both MyISAM tables, which support full-text search, and InnoDB tables, which support transactions at the level of individual records. In addition, the MySQL DBMS comes with a special EXAMPLE table type, which demonstrate examples and principles of creating new table types. Thanks to the free architecture and GPL-licensing, new and new types of tables are constantly appearing in the MySQL DBMS.
MySQL is ported to a wide variety of platforms: AIX, BSDi, FreeBSD, HP-UX, Linux, macOS, NetBSD, OpenBSD, OS / 2 Warp, SGI IRIX, Solaris, SunOS, SCO OpenServer, UnixWare, Tru64, Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP, Windows Server 2003, WinCE, Windows Vista, Windows 7 and Windows 10. There is also a MySQL port to OpenVMS. On the official Oracle website, not only source codes are provided for free download, but also compiled and optimized for specific operating systems ready-made executable modules of the MySQL DBMS.
MySQL has a fluent API for languages such as Delphi, C, C ++, Eiffel, Java, Lisp, Perl, PHP, Python, Ruby, Smalltalk, Component Pascal and Tcl, libraries for .NET platform languages, and MySQL also provides support for ODBC using the MyODBC ODBC driver.