Added new C API function mysql_ping()
.
Added new API functions mysql_init()
and
mysql_options()
. You now MUST call
mysql_init()
before you call
mysql_real_connect()
. You don't have to
call mysql_init()
if you only use
mysql_connect()
.
Added
mysql_options(...,MYSQL_OPT_CONNECT_TIMEOUT,...)
so you can set a timeout for connecting to a server.
Added --timeout
option to
mysqladmin
, as a test of
mysql_options()
.
Added AFTER column
and
FIRST
options to ALTER TABLE ...
ADD columns
. This makes it possible to add a new
column at some specific location within a row in an existing
table.
WEEK()
now takes an optional argument to
allow handling of weeks when the week starts on Monday (some
European countries). By default, WEEK()
assumes the week starts on Sunday.
TIME
columns weren't stored properly (bug
in MySQL Version 3.22.0).
UPDATE
now returns information about how
many rows were matched and updated, and how many
``warnings'' occurred when doing the update.
Fixed incorrect result from
FORMAT(-100,2)
.
ENUM
and SET
columns
were compared in binary (case-sensitive) fashion; changed to
be case-insensitive.
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.