|
[[sv:MySQL]]
The '''MySQL''' issystem aimplements verya fast, multi-threaded, multi-user and robust [[SQL]] (Structured Query Language) [[relational database]] server. MySQL isas [[free software]]: it is licensed underutilises the [[GNU General Public License]]. ItThe wasSwedish writtencompany andMySQL isAB maintainedwrites byand maintains the Swedish company MySQL ABsystem, which sellsselling support and service contracts as well as commercially licensed copies of MySQL and employsemploying people all over the world who communicate over the internet. [[MySQL ABinternet]]. was set up by twoTwo Swedes and a Finn founded [[MySQL AB]]: [[David Axmark]], [[Allan Larsson]] and [[Michael (Monty) Widenius|Michael "Monty" Widenius]]. Despite the widespread pronunciation of SQL beingas "sequel", the[[profession]]als generally accepted pronunciation ofpronounce "MySQL" by professionals isas "My ess-que-ell", not "My-Sequel".
==Platforms==
MySQL, isan [[open source]] andproduct, works on many different platforms including [[AIX operating system|AIX]], [[BSDi]], [[FreeBSD]], [[HP-UX]], [[Linux]], [[Mac OS X]], [[NetBSD]], [[OpenBSD]], [[OS/2]] Warp, [[SGI]] [[IRIX]], [[Solaris Operating Environment|Solaris]], [[SunOS]], SCO OpenServer, SCO UnixWare, [[Tru64]], [[Microsoft Windows|Windows]] 95, 98, NT and 2000.
==Programming Languages==
MySQL databases can be accessed using the [[programming language|programmingProgramming languages]] which can access MySQL databases include [[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, using a specific [[API]] is available. An [[ODBC]] interface called MyODBC is also availableexists. MySQL's uses C as its "native" language is C.
==Early versions==
Early versions of MySQL included few standard DBMS features. This led some database experts, such as [[Christopher J. Date|Chris Date]] and [[Fabian Pascal]], to criticize MySQL, particularly for the lack of transactions, as well as 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/]
==The latest production version==
TheAs latestof [[as of 2003 | 2003]] MySQL offers production version is 4.0. It includes the following features:
* A broad subset of ANSI SQL 99, as well as extensions.
* Cross-platform support
* Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity)
==The development version==
VersionAs 4.1of is[[as of 2003 | 2003]] the development version, andVersion 4.1, includes support for the following features:
* Sub-SELECTS
* UTF-8
==Wikipedia on MySQL==
In [[August 2001]], a test version of the [[Wikipedia]] software using [[PHP programming language|PHP]] and MySQL appeared; in January 2002 it was adopted asbecame the new software running Wikipedia. See the [[Wikipedia:MediaWiki|MediaWiki]] page. In May 2003, this code base wasunderwent an [[m:Upgrade to MySQL 4.0|upgradedupgrade to MySQL version 4.0.12]] from the previous version 3.x.
See also: [[PostgreSQL]], [[Berkeley DB]]
|
