How to run MySQL in ANSI mode

You can use the "--ansi" startup option to require MYSQLD to use ANSI mode.

Running the server in ANSI mode is the same as the effect of starting it with this option (specifying the "--sql_mode" value on one line):

--transaction-isolation=SERIALIZABLE
--sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
IGNORE_SPACE

In MySQL4.1, you can use the following two statements to achieve the same effect (Specify a "Sql_mode" value on one line):

SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET GLOBAL sql_mode = 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
IGNORE_SPACE';

In the MySQL 4.1.1, you can also set the Sql_mode option with the following statement:

SET GLOBAL sql_mode='ansi';

In this case, set the value of the Sql_mode variable to all the options associated with ANSI mode. You can check the results as follows:

mysql> SET GLOBAL sql_mode='ansi';
mysql> SELECT @@global.sql_mode;
　　　-> 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
IGNORE_SPACE,ANSI';