Portable to more systems because of MIT-pthreads, which will
be used automatically if
Added GNU-style long options to almost all programs. Test
Some shared library support for Linux.
The FAQ is now in
.texi format and is
Added new SQL function
sql_lex to handle
\0 unquoted, but the client can't send
the query through the C API, because it takes a str pointer.
You must use
mysql_real_query() to send
Added API function
mysqld now uses the
nisam.h as the maximum allowable key
The following now works:
SELECT filter_nr,filter_nr FROM filter ORDER BY filter_nr;
Previously, this resulted in the error:
'filter_nr' in order clause is ambiguous.
mysql now outputs
encountering ASCII 0, tab, newline or
while writing tab-separated output. This is to allow
printing of binary data in a portable format. To get the old
Added german error messages (60 of 80 error messages translated).
Added new API function
mysql_fetch_lengths(MYSQL_RES *), which
returns an array of column lengths (of type
Fixed bug with
IS NULL in
Changed the optimizer a little to get better results when searching on a key part.
STRAIGHT_JOIN to tell the optimizer that
it should join tables in the given order.
Added support for comments starting with
You can have
SELECT expressions and table
columns in a
SELECT which are not used in
the group part. This makes it efficient to implement
lookups. The column that is used should be a constant for
each group because the value is calculated only once for the
first row that is found for a group.
SELECT id,lookup.text,SUM(*) FROM test,lookup->
WHERE test.id=lookup.id GROUP BY id;
Fixed bug in
SUM(function) (could cause a
AUTO_INCREMENT placement in the
INSERT INTO table (auto_field) VALUES (0);
inserted 0, but it should insert an
mysqlshow.c: Added number of records in
table. Had to change the client code a little to fix this.
mysql now allows doubled
strings for embedded
New math functions:
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.