· 6 years ago · Sep 18, 2019, 08:26 AM
1create table if not exists emp (EmpNo int(4) not null, EName varchar(32), Dept int(2), HireDate date);
2
3insert into emp values(7389, 'King',10,20011221), (7698, 'Blake’,30,20101112), (7782, 'Clark’,10,20100304), (7566, 'Jones’,20,20100411), (7654, 'Martin’,30,20080303), (7499, 'Allen’,30,20091003), (7844, 'Turner’,30,20090703), (7900, 'James’,30,20080603), (7521, 'Ward’,30,20091212), (7902, 'Ford’,20,20091203), (7369, 'Smith’,20,20061003), (7788, 'Scott’,20,20091103), (7876, 'Adams’,20,20090403), (7934, 'Miller’,10,20090503);