Ashok Kumar wrote:
Hi friends,
I'm having one doubt on "NOT NULL" specification for
the table field properties. That is i have created on
table-mine which contains name(Not Null) and pwd(Not
Null). Now I intended to execute the following query.
"insert into mine values('','')"
This means that i'm trying to insert the null fields
to the table. but this query is successfully executed
and 1 row is inserted into table with empty values.
why it's happening and how can i resolve this problem.
Pls give me suggestions regarding this.
Thanks and Regards,
Ashok Kumar.P.S
Because '' is an empty string, not NULL.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]