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
2010/1/30 Claudio Nanni <claudio.nanni@stripped>
> Take a look at SQL_MODE ;)
> On Jan 30, 2010 5:05 PM, "Miao Jiang" <jiangfriend@stripped> 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: