MySQL :: MySQL 5.1 Reference Manual :: 1.8.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 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 th

[jmala]

2006/03/11 02:04:01

[friction]

↓と思ってたらANSIModeとやらがあるらしい。