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
thanks
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Thursday, December 29, 2005 10:38 PM
Subject: (ÈðÐÇÌáʾ-´ËÓʼþ¿ÉÄÜÊÇÀ¬»øÓʼþ)RE: set sql mode
An error is only thown during an INSERT or UPDATE statement, otherwise
you just get
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?
|
+---+
| 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
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