AS 1.7.3. Running MySQL in ANSI Mode explain:
------------------------------------------------------------------ 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--------------------------------------------------------------------If transaction isolation auto setting as SERIALIZABLE when i setting sql mode equal to "ansi"?On this condition,if the transation-isolation make no effect?What will happened if i set sql mode equal to "ansi" and transation-isolation equal to "READ COMMITTED"?