I'm doing experiments with the table "pet" where the field "birth" is of
type "date". How come
UPDATE pet SET birth = "a2b" WHERE name = "snort";
gives:
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 1
but
UPDATE pet SET birth = "ab" WHERE name = "snort";
gives:
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
After a few more tests I determined that I'm getting a warning if I try to
set the field to a value consisting of a mixture of letters and numbers,
but I get no warning if the new value consists only of letters. Shouldn't
I get a warning if I try to set a date field to a value consisting of all
letters?
-Bennett
[EMAIL PROTECTED] http://www.peacefire.org
(425) 649 9024
---------------------------------------------------------------------
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
