(mysql.info) ansi-mode
Info Catalog
(mysql.info) sql-mode
(mysql.info) compatibility
(mysql.info) extensions-to-ansi
1.9.3 Running MySQL in ANSI Mode
--------------------------------
You can tell `mysqld' to run in ANSI mode with the -ansi startup
option. Running the server in ANSI mode is the same as starting it with
the following options:
--transaction-isolation=SERIALIZABLE --sql-mode=ANSI
As of MySQL 4.1.1, you can achieve the same effect at runtime by
executing these two statements:
SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET GLOBAL sql_mode = 'ANSI';
You can see that setting the `sql_mode' system variable to `'ANSI''
enables all SQL mode options that are relevant for ANSI mode as follows:
mysql> SET GLOBAL sql_mode='ANSI';
mysql> SELECT @@global.sql_mode;
-> 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI'
Note that running the server in ANSI mode with -ansi is not quite the
same as setting the SQL mode to `'ANSI''. The -ansi option affects the
SQL mode and also sets the transaction isolation level. Setting the SQL
mode to `'ANSI'' has no effect on the isolation level.
See server-options, and sql-mode.
Info Catalog
(mysql.info) sql-mode
(mysql.info) compatibility
(mysql.info) extensions-to-ansi
automatically generated byinfo2html