RE: date and not null

2003-12-21 Thread Andrew Braithwaite
(8,2) | YES | | NULL| | In your mysql> desc log_book; Cheers, A -Original Message- From: landon kelsey [mailto:[EMAIL PROTECTED] Sent: Sunday 21 December 2003 23:12 To: [EMAIL PROTECTED] Subject: date and not null why did this date work: insert into log_book values ('

date and not null

2003-12-21 Thread landon kelsey
why did this date work: insert into log_book values ('08-12-1973','C150','N5787G',1,1.8); date looks good in table...has been rearranged to std format and this didn't insert into salesreps values (109,'Mary Jones',31,11,'Sales Rep','10-12-1989',106,30.00,392725.00); date is -00-00 in