From: Claudio Nanni
Date: January 30 2010 4:28pm
Subject: Re: How to force Warning: #1048 Column cannot be null to Error
List-Archive: http://lists.mysql.com/mysql/220503
Message-Id: <53bcf3a61001300828q4d6d7f0ajc3435649a3f1b9ea@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001485f796e493fd87047e643f91

--001485f796e493fd87047e643f91
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Take a look at SQL_MODE ;)

Claudio

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 =E3=80=82
I want to MySQL raise an exception when I try do that.
How to do that?

Thank you.
Miao


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Dclaudio.nanni@stripped

--001485f796e493fd87047e643f91--