Warning: Incompatible
change! mysqlperl
is now from
Msql-Mysql-modules. This means that
connect()
now takes
host
, database
,
user
, password
arguments! The old version took host
,
database
, password
,
user
.
Allow DATE '1997-01-01'
, TIME
'12:10:10'
and TIMESTAMP '1997-01-01
12:10:10'
formats required by SQL-99.
Warning: Incompatible
change! This has the unfortunate side-effect that
you no longer can have columns named
DATE
, TIME
or
TIMESTAMP
. :( Old columns can still be
accessed through tablename.columnname
!)
Changed Makefiles to hopefully work better with BSD systems.
Also, manual.dvi
is now included in the
distribution to avoid having stupid make
programs trying to rebuild it.
readline
library upgraded to version 2.1.
A new sortorder german-1. That is a normal ISO-Latin1 with a german sort order.
Perl DBI
/DBD
is now
included in the distribution. DBI
is now
the recommended way to connect to MySQL from Perl.
New portable benchmark suite with DBD
,
with test results from mSQL
2.0.3, MySQL,
PostgreSQL 6.2.1 and Solid server 2.2.
crash-me
is now included with the
benchmarks; this is a Perl program designed to find as many
limits as possible in an SQL server. Tested with
mSQL
, PostgreSQL, Solid and MySQL.
Fixed bug in range-optimizer that crashed MySQL on some queries.
Table and column name completion for
mysql
command-line tool, by Zeev Suraski
and Andi Gutmans.
Added new command REPLACE
that works like
INSERT
but replaces conflicting records
with the new record. REPLACE INTO TABLE ... SELECT
...
works also.
Added new commands CREATE DATABASE
db_name
and DROP DATABASE
db_name
.
Added RENAME
option to ALTER
TABLE
: ALTER TABLE name RENAME TO
new_name
.
make_binary_distribution
now includes
libgcc.a
in
libmysqlclient.a
. This should make
linking work for people who don't have
gcc
.
Changed net_write()
to
my_net_write()
because of a name conflict
with Sybase.
Stack checking and bison
memory overrun
checking to make MySQL safer with weird queries.
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.