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 <claudio.na...@gmail.com> > Take a look at SQL_MODE ;) > > Claudio > > On Jan 30, 2010 5:05 PM, "Miao Jiang" <jiangfri...@gmail.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.na...@gmail.com >
