An error is only thown during an INSERT or UPDATE statement, otherwise you just get a warning.
- ERROR_FOR_DIVISION_BY_ZERO Produce an error in strict mode (otherwise a warning) when we encounter a division by zero (or MOD(X,0)) during an INSERT or UPDATE. If this mode is not given, MySQL instead returns NULL for divisions by zero. If used in INSERT IGNORE or UPDATE IGNORE, MySQL generates a warning for divisions by zero, but the result of the operation is NULL. Ed -----Original Message----- From: wangxu [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 7:23 PM To: Gleb Paharenko; mysql@lists.mysql.com Subject: Re: set sql mode 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
