OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: How to force Warning: #1048 Column cannot be null to Error

From: Claudio Nanni (claudio.nannigmail.com)
Date: Sat Jan 30 2010 - 10:28:55 CST


Take a look at SQL_MODE ;)

Claudio

On Jan 30, 2010 5:05 PM, "Miao Jiang" <jiangfriendgmail.com> 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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=claudio.nannigmail.com