thanks
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
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 g
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 -
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_FLOA
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|
+
