|
MySQL is a client/server implementation that consists of a
server daemon (mysqld) and many different client programs and
libraries. MySQL is a true multi-user, multi-threaded SQL database
server. A very fast thread-based memory allocation system.
No memory leaks. Tested with a commercial memory leakage detector
(purify). Includes isamchk, a very fast utility for table checking,
optimization and repair.
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'.
|