MySQL: Difference between revisions

Revision as of 19:07, 9 August 2003

Revision as of 19:28, 9 August 2003

Line 8:

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

A development version of MySQL 4.1, containing support for "Sub-SELECTs" was released in January 2003. Version 4.1 also contains support for UTF-8. MySQL originally lacked support for [[transaction|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 features which are not yet implemented are:

* "Sub-SELECTs" or "nested SELECTs". The MySQL website states that "Subselects are currently being implemented in the 4.1 development tree."

* multibyte character encoding or [[Unicode]]/[[UTF-8]]

A development version of MySQL 4.1, containing support for "Sub-SELECTs" was released in January 2003. Version 4.1 also contains support for UTF-8. MySQL originally lacked support for [[transaction|transactions]], however this feature is now available.

In [[August 2001]], a test version of the [[Wikipedia]] software using [[PHP programming language|PHP]] and MySQL appeared; in January 2002 it was adopted as the new software running Wikipedia. See the [[wikipedia:PHP script|Wikipedia PHP script]] page. In May 2003, this code base was [[m:Upgrade to MySQL 4.0|upgraded to MySQL version 4.0.12]] from the previous version 3.x.

Other standard SQL features MySQL has not implemented include [[referential integrity]] constraints and [[stored procedure]]s. Some database experts including [[Christopher J. Date|Chris Date]] and [[Fabian Pascal]] have criticized MySQL particularly for the lack of enforced integrity constraints, which in other DBMSes allow the database system to ensure that applications cannot insert inconsistent values. [http://www.dbdebunk.com/]

In [[August 2001]], a test version of the [[Wikipedia]] software using [[PHP programming language|PHP]] and MySQL appeared; in January 2002 it was adopted as the new software running Wikipedia. See the [[wikipedia:PHP script|Wikipedia PHP script]] page. In May 2003, this code base was [[m:Upgrade to MySQL 4.0|upgraded to MySQL version 4.0.12]] from the previous version 3.x.

See also: [[PostgreSQL]], [[Berkeley DB]]