Running MySQL in ANSI Mode

Running MySQL in ANSI Mode
You can tell mysqld to run in ANSI mode with the --ansi [428] startup option. Running the server in
ANSI mode is the same as starting it with the following options:
--transaction-isolation=SERIALIZABLE --sql-mode=ANSI
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 [557] 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'
Running the server in ANSI mode with --ansi [428] is not quite the same as setting the SQL mode
to 'ANSI'. The --ansi [428] 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.
... zobacz całą notatkę