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]
