(mysql.info) sql-mode

Info Catalog

(mysql.info) standards

(mysql.info) compatibility

(mysql.info) ansi-mode

 
 1.9.2 Selecting SQL Modes
 -------------------------
 
 The MySQL server can operate in different SQL modes, and can apply
 these modes differentially for different clients. This capability
 enables each application to tailor the server's operating mode to its
 own requirements.
 
 SQL modes control aspects of server operation such as what SQL syntax
 MySQL should support and what kind of data validation checks it should
 perform. This makes it easier to use MySQL in different environments
 and to use MySQL together with other database servers.
 
 You can set the default SQL mode by starting `mysqld' with the
 -sql-mode="MODE_VALUE" option. Beginning with MySQL 4.1, you can also
 change the mode at runtime by setting the `sql_mode' system variable
 with a `SET [SESSION|GLOBAL] sql_mode='MODE_VALUE'' statement.
 
 For more information on setting the SQL mode, see 
 server-sql-mode.
 

Info Catalog

(mysql.info) standards

(mysql.info) compatibility

(mysql.info) ansi-mode