language: SQL

Supported operators include <>, <, >, contains, begins, and =.

-

Full source code available

-

Complex expression parser

-

Implicit joins

-

Variable length fields and records

-

Multi-Attribute B-Tree indexes

-

Subset of SQL

Full support for the ISO-8859-1 Latin1 character set. For example, the Scandinavian characters @ringaccent{a}, @"a and @"o are allowed in table and column names.

All data are saved in ISO-8859-1 Latin1 format. All comparisons for normal string columns are case insensitive.

Sorting is done according to the ISO-8859-1 Latin1 character set (the Swedish way at the moment). It is possible to change this in the source by adding new sort order arrays. To see an example of very advanced sorting, look at the Czech sorting code. MySQL supports many different character sets that can be specified at compile time. Aliases on tables and columns as in the SQL92 standard. DELETE, INSERT, REPLACE, and UPDATE return how many rows were changed (affected).

Function names do not clash with table or column names. For example, ABS is a valid column name. The only restriction is that for a function call, no spaces are allowed between the function name and the `(' that follows it.

Clients connect to the MySQL server using TCP/IP connections or Unix sockets, or named pipes under NT.

The EXPLAIN command can be used to determine how the optimizer resolves a query.

The January 1999 issue of Linux Journal reported that the 1998 Readers Choice Award chose MySQL as the 'Most Used Database over the Internet'.