Not sure how the first insert worked - couldn't test it as the create table syntax is not valid - "nlandings number" and "nhours number" - not sure how they produced the schema:
| nlandings | int(11) | YES | | NULL | | | nhours | double(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 ('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,300000.00,392725.00); date is 0000-00-00 in table create table log_book (fdate date, actype varchar2(16), acid varchar(16), nlandings number, nhours number); create table salesreps (empl_num int(8) not null, name varchar(15) not null, age int(8), rep_office int(8), title varchar(10), hire_date date not null, manager int(8), quota float(10,2), sales float(10,2) not null, primary key (empl_num )); must be the not null!!! mysql> desc log_book; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | fdate | date | YES | | NULL | | | actype | varchar(16) | YES | | NULL | | | acid | varchar(16) | YES | | NULL | | | nlandings | int(11) | YES | | NULL | | | nhours | double(8,2) | YES | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.00 sec) mysql> desc salesreps; +------------+-------------+------+-----+------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+------------+-------+ | empl_num | int(8) | | PRI | 0 | | | name | varchar(15) | | | | | | age | int(8) | YES | | NULL | | | rep_office | int(8) | YES | | NULL | | | title | varchar(10) | YES | | NULL | | | hire_date | date | | | 0000-00-00 | | | manager | int(8) | YES | | NULL | | | quota | float(10,2) | YES | | NULL | | | sales | float(10,2) | | | 0.00 | | +------------+-------------+------+-----+------------+-------+ 9 rows in set (0.00 sec) _________________________________________________________________ Have fun customizing MSN Messenger - learn how here! http://www.msnmessenger-download.com/tracking/reach_customize -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
