At 11:50 +0800 12/30/05, wangxu wrote:
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"?
As the referenced manual page indicates, "running the server in ANSI mode"
means starting the server with the --ansi option.
That's not the same as setting the SQL mode to "ANSI" (--sql-mode=ANSI).
Setting the SQL mode does not have any effect on the isolation level.
Setting the SQL mode to ANSI is not the same as using --ansi.
You can set the isolation level to READ COMMITTED if you like.
Using --ansi sets the isolation level as one of its effects. But
clients can change the isolation level when they connect if they like.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]