Hello.
>But now i wish sql mode only include "REAL_AS_FLOAT,PIPES_AS_CONCAT". Do you want this: mysql> set @@sql_mode='REAL_AS_FLOAT,PIPES_AS_CONCAT'; Query OK, 0 rows affected (0.00 sec) mysql> select @@sql_mode; +-------------------------------+ | @@sql_mode | +-------------------------------+ | REAL_AS_FLOAT,PIPES_AS_CONCAT | +-------------------------------+ >It showing >"REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI" when i >set sql mode is "ansi". >But now i wish sql mode only include "REAL_AS_FLOAT,PIPES_AS_CONCAT". >Can I achieve it?wangxu wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]