MySQL

From Wikipedia

HomePage | Recent changes | View source | Discuss this page | Page history | Log in |

Printable version | Disclaimers | Privacy policy

MySQL is a very fast, multi-threaded, multi-user and robust SQL (Structured Query Language) relational database server. MySQL is free software: it is licensed under the GNU General Public License. It was written and is maintained by the Swedish company MySQL AB, which sells support and service contracts as well as commercially licenced copies of MySQL and employs people all over the world who communicate over the internet.

MySQL originally lacked support for transactions, however this feature is now available. The full ANSI SQL standard is extended in some areas and not implemented in others; probably the most often requested feature which is not yet implemented is "Sub-SELECTs" or "nested SELECTs".

MySQL is open source and works on many different platforms including AIX, BSDi, DEC Unix, FreeBSD, HP-UX, Linux, Mac OS X, NetBSD, OpenBSD, OS/2 Warp, SGI Irix, Solaris, SunOS, SCO OpenServer, SCO UnixWare, Tru64 Unix, Windows 95, 98, NT and 2000.

MySQL databases can be accessed using the programming languages C, C++, Eiffel, Java, Perl, PHP, Python, and Tcl; for each of these, a specific API is available. An ODBC interface called MyODBC is also available.

The preferred pronunciation of MySQL is "My S-Q-L", and not "My-Sequel".


In August 2001, a test version of Wikipedia using PHP and MySQL appeared, see the Wikipedia PHP script page.



See also: PostgreSQL, Berkeley DB

External links: MySQL web site at http://www.mysql.com


/Talk