Harald Fuchs wrote:
You _did_ enter some data, namely a string which just happens to be
the empty string (which in turn is different from "no data", i.e. NULL).
How should MySQL know that you don't want empty strings?
I think the user expects:
INSERT INTO table (bar) VALUES ("text");
to behave the same as:
INSERT INTO table (foo, bar) VALUES (NULL, "text");
which would throw an error (correctly).
No comment ;-)
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php