The configure
source now compiles a
thread-free client library -lmysqlclient
.
This is the only library that needs to be linked with client
applications. When using the binary releases, you must link
with -lmysql -lmysys -ldbug -lmystrings
as before.
New readline
library from
bash-2.0
.
LOTS of small changes to configure
and
makefiles (and related source).
It should now be possible to compile in another directory
using VPATH
. Tested with GNU Make 3.75.
safe_mysqld
and
mysql.server
changed to be more
compatible between the source and the binary releases.
LIMIT
now takes one or two numeric
arguments. If one argument is given, it indicates the
maximum number of rows in a result. If two arguments are
given, the first argument indicates the offset of the first
row to return, the second is the maximum number of rows.
With this it's easy to do a poor man's next page/previous
page WWW application.
Changed name of SQL function FIELDS()
to
ELT()
. Changed SQL function
INTERVALL()
to
INTERVAL()
.
Made SHOW COLUMNS
a synonym for
SHOW FIELDS
. Added compatibility syntax
FRIEND KEY
to CREATE
TABLE
. In MySQL, this creates a non-unique key on
the given columns.
Added CREATE INDEX
and DROP
INDEX
as compatibility functions. In MySQL,
CREATE INDEX
only checks if the index
exists and issues an error if it doesn't exist.
DROP INDEX
always succeeds.
mysqladmin.c
: added client version to
version information.
Fixed core dump bug in sql_acl
(core on
new connection).
Removed host
, user
and
db
tables from database
test
in the distribution.
FIELD_TYPE_CHAR
can now be signed (-128
to 127) or unsigned (0 to 255) Previously, it was always
unsigned.
Bug fixes in CONCAT()
and
WEEKDAY()
.
Changed a lot of source to get mysqld
to
be compiled with SunPro compiler.
SQL functions must now have a '('
immediately after the function name (no intervening space).
For example, 'USER('
is regarded as
beginning a function call, and 'USER ('
is regarded as an identifier USER
followed by a '('
, not as a function
call.
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.