In addition to my previous post, if I use the INSERT command like:
mysql> INSERT INTO pet VALUES ('bark',NULL,'dog','m','2000-01-30',NULL);
the NULL values are entered correctly:
mysql> SELECT * FROM pet;
+----------+--------+---------+------+------------+------------+
| name | owner | species | sex | birth | death |
+----------+--------+---------+------+------------+------------+
[snip]
| bark | NULL | dog | m | 2000-01-30 | NULL |
+----------+--------+---------+------+------------+------------+
16 rows in set (0.00 sec)
Thanks in advance for any suggestions.
--
# Mertens Bram "M8ram" <[EMAIL PROTECTED]> Linux User #249103 #
# Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM #
# A priest advised Voltaire on his death bed to renounce the devil. #
# Replied Voltaire, "This is no time to make new enemies." #
---------------------------------------------------------------------
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
