My sql_mode is "STRICT_TRANS_TABLES,ANSI_QUOTES,ERROR_FOR_DIVISION_BY_ZERO".
But when i execute "select 1/0 from ht_detail",the result is "Null". No error throw out. Why? ----- Original Message ----- From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Wednesday, December 28, 2005 9:26 PM Re: set sql mode > 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] > >
