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]
