New reserved words used:
Added ODBC function
IN. This uses a binary
search to find a match.
LOCK TABLES tbl_name [AS alias]
--log-update option to
mysqld, to get a log suitable for
EXPLAIN SELECT ... to get
information about how the optimizer will do the join.
For easier client code, the client should no longer use
FIELD_TYPE_VAR_STRING (as previously
should instead only use
FIELD_TYPE_STRING. If you want exact
types, you should use the command
Added varbinary syntax:
can be used as a string (default) or a number.
FIELD_TYPE_CHAR is renamed to
Changed all fields to C++ classes.
Removed FORM struct.
DEFAULT values no longer need
New field types:
A string which can take only a couple of defined values. The value is stored as a 1-3 byte number that is mapped automatically to a string. This is sorted according to string positions!
A string which may have one or many string values separated with ','. The string is stored as a 1-, 2-, 3-, 4- or 8-byte number where each bit stands for a specific set member. This is sorted according to the unsigned value of the stored packed number.
Now all function calculation is done with
This will provide the full 64-bit range with bit functions
and fix some conversions that previously could result in
precision losses. One should avoid using
long long columns with full 64-bit range (numbers
bigger than 9223372036854775807) because calculations are
signed long long.
ORDER BY will now put
NULL field values first.
BY will also work with
WHERE with expressions.
New range optimizer that can resolve ranges when some keypart prefix is constant. Example:
SELECT * FROM tbl_name->
AND key_part_2>=10 AND key_part_2<=10;
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.