mysql> SET sql_mode = TRADITIONAL;
Query OK, 0 rows affected (0.02 sec)
Then the insert query will fail and the row will not be added to the
table...see you.
Wagner Bianchi
2010/1/30 Claudio Nanni
> Take a look at SQL_MODE ;)
>
> Claudio
>
> On Jan 30, 2010 5:05 PM, "Miao Jiang" wrote:
>
> W
Take a look at SQL_MODE ;)
Claudio
On Jan 30, 2010 5:05 PM, "Miao Jiang" wrote:
When I try insert NULL to VARCHAR NOT NULL column, It will shows a warning
and convert NULL to '' then insert 。
I want to MySQL raise an exception when I try do that.
How to do that?
Thank you.
Miao
--
MySQL Ge
When I try insert NULL to VARCHAR NOT NULL column, It will shows a
warning and convert NULL to '' then insert 。
I want to MySQL raise an exception when I try do that.
How to do that?
Thank you.
Miao
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: