(mysql.info.gz) ANSI mode

Info Catalog

(mysql.info.gz) SQL mode

(mysql.info.gz) Compatibility

(mysql.info.gz) Extensions to ANSI

 
 1.5.3 Running MySQL in ANSI Mode
 --------------------------------
 
 You can tell `mysqld' to use the ANSI mode with the `--ansi' startup
 option.  Server options.
 
 Running the server in ANSI mode is the same as starting it with these
 options (specify the `--sql_mode' value on a single line):
 
      --transaction-isolation=SERIALIZABLE
      --sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
      IGNORE_SPACE,ONLY_FULL_GROUP_BY
 
 In MySQL 4.1, you can achieve the same effect with these two statements
 (specify the `sql_mode' value on a single line):
 
      SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
      SET GLOBAL sql_mode = 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
      IGNORE_SPACE,ONLY_FULL_GROUP_BY';
 
  SQL mode.
 
 In MySQL 4.1.1, the `sql_mode' options shown can be also be set with
 this statement:
 
      SET GLOBAL sql_mode='ansi';
 
 In this case, the value of the `sql_mode' variable will be set to all
 options that are relevant for ANSI mode. You can check the result like
 this:
 
      mysql> SET GLOBAL sql_mode='ansi';
      mysql> SELECT @@global.sql_mode;
              -> 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
                  IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI';
 

Info Catalog

(mysql.info.gz) SQL mode

(mysql.info.gz) Compatibility

(mysql.info.gz) Extensions to ANSI