create table dept
deptno varchar(10) primary key comment '部门号，
dname varchar( 10) comment '部门名!
create table emp
empno varchar(10) primary key comment '员工号'
ename varchar(10) comment '姓名'，
job varchar 10) comment '工作'，
mgr varchar(10) comment '管理者姓名'),
salary varchar(10) comment '工资'，
deptno varchar(10) references dept(deptno) comment'部门号'
insert into dept values (1','事业部');
insert into dept values ('2','销售部);
insert into dept values ('3''技术部');
insert into emp values(01',jacky','clerk','tom','1000','1');
insert into emp values (02,'tom','clerk',",'2000','1);
insert into emp values ('03','biddy','clerk,",'2000','1);
insert into emp values(04,'jenny','sales,'pretty','600',2);
insert into emp values (O5','pretty','sales',",'800','2');
insert into emp values ('06,' buddy';'jishu','canndy',' 1000',3');
insert into emp values (07,'canndy,'jishu,",'1500',3');