t; thanks
>
> regards,
> sreedhar
>
>
> - Original Message -
> From: "Paul DuBois" <[EMAIL PROTECTED]>
> To: "sreedhar" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
> Sent: Wednesday, December 12, 2001 11:25
" <[EMAIL PROTECTED]>
To: "sreedhar" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 11:25 PM
Subject: Re: NOT NULL field accepting NULL
> At 7:12 PM +0530 12/12/01, sreedhar wrote:
> >Hi All,
> >
No, it's not accepting NULL if it was declared as NOT NULL.
It's just accepting an empty sting ( "" ).
CREATE TABLE test (t VARCHAR(10) NOT NULL);
INSERT INTO test SET t = NULL;
INSERT INTO test SET t = '';
First insert will tell you what you're waiting for. And the second one
will do what you
At 7:12 PM +0530 12/12/01, sreedhar wrote:
>Hi All,
>
>In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What
>might be the
>problem. please let me know.
>
>regards,
>sreedhar
That's not enough information.
Let's see the CREATE TABLE statement, a sample INSERT statement, and
t
