1)建立表
a )雇员表
drop table if exists emp;
create table emp(
empno int(4) primary key comment '雇员编号',
ename varchar(10) comment '官员姓名',
job varchar(9) comment '雇员职位',
mgr int(4) comment '领导编号',
hiredate datetime comment '入职日期',
sal double(7,2) comment '薪资',
comm double(7,2) comment '奖金',
deptno int(2) comment '部门编号'
);
向表中插入数据:
insert into emp values(7369,'SMITH','CLERK',7902,'1980-12-17',800,null,20);
insert into emp values(7499,'ALLEN','SALESMAN',7698,'1981-01-20',1600,300,30);
insert into emp values(7521,'WARD','SALESMAN',7698,'1981-02-22',1250