MySQL: Difference between revisions

Revision as of 08:30, 25 November 2003

Revision as of 08:35, 25 November 2003

Line 6:

[[sv:MySQL]]

The '''MySQL''' system implements a fast, multi-threaded[[thread]]ed, [[multi-user]] and robust [[SQL]] (Structured Query Language) [[relational database]] [[server]]. MySQL as [[free software]] utilises the [[GNU General Public License]]. The Swedish company MySQL AB writes and maintains the system, selling support and service contracts as well as commercially licensed copies of MySQL and employing people all over the world who communicate over the [[internet]]. Two Swedes and a Finn founded [[MySQL AB]]: [[David Axmark]], [[Allan Larsson]] and [[Michael (Monty) Widenius|Michael "Monty" Widenius]]. Despite the widespread pronunciation of SQL as "sequel", [[profession]]als generally pronounce "MySQL" as "My ess-que-ell", not "My-Sequel".

==Platforms==

MySQL, an [[open source]] product, 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, 2000, [[XP]] and 2000higher.

==Programming Languages==

[[programming language|Programming 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]]; each of these using a specific [[API]]. An [[ODBC]] interface called [[MyODBC]] also exists. MySQL uses C as its "native" language.

==The latest production version==

Line 20:

* Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity)

* Transactions

* [[SSL]] Support

* Query [[caching]]

* Replication

* Full-text [[indexing]] and searching

* Embedded database library

It does not include the following features:

* Sub-SELECTs[[SELECT]]s (or nested SELECTs)

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

* Stored procedures

Line 35:

* Sub-SELECTS

* UTF-8

* Support for geographical data ([[OpenGIS]])

* Derived tables

* Multi-line queries

Line 42:

MySQL 5.0 will contain support for the following features:

* Stored procedures

* [[Trigger]]s

* Triggers

* [[Cursor]]s

* Cursors

* True VARCHAR support

* Easier GIS access

Line 49:

MySQL 5.1 will contain support for:

* Foreign key support for all table types

* Online [[backup]]

* Fail-safe replication

* Column-level constraints