SQLsever练习题

数据库练习

数据库数据

 #部门表
create table dept(
 deptno int primary key auto_increment comment 部门编号,  
 dname varchar(14) ,   #部门名字
 loc varchar(13)   #地址
) ;
 #员工表
create table emp(
 empno int primary key auto_increment, #员工编号
 ename varchar(10), #员工姓名          -
 job varchar(9), #岗位
 mgr int, #直接领导编号
 hiredate date, #雇佣日期，入职日期
 sal int, #薪水
 comm int,   #提成
 deptno int not null, #部门编号
 foreign key (deptno) references dept(deptno)
);
insert into dept values(10,'财务部','北京');
insert into dept values(20,'研发部','上海');
insert into dept values(30,'销售部','广州');
insert into dept values(40,'行政部','深圳');
insert into emp values(7369,'刘一','职员',7902,'1980-12-17',800,null,20);
insert into emp values(7499,'陈二','推销员',7698,'1981-02-20',1600,300,30);
insert into emp values(7521,'张三','推销员',7698,'1981-02-22',1250,500,30);
insert into emp values(7566,'李四','经理',7839,'1981-04-02',2975,null,20);
insert into emp values(7654,'王五','推销员',7698,'1981-09-28',1250,1400,30);
insert into emp values(7698,'赵六','经理',7839,'1981-05-01',2850,null,30);
insert into emp values(7782,'孙七','经理',7839,'1981-06-09',2450,null,10);
insert into emp values(7788,'周八','分析师',7566,'1987-06-13',3000,null,20);
insert into emp values(7839,'吴九','总裁',null,'1981-11-17',5000,null,10);
insert into emp values(7844,'郑十','推销员',7698,'1981-09-08',1500,0,30);
insert into emp values(7876,'郭十一','职员',7788,'1987-06-13',1100,null,20);
insert into emp values(7900,'钱多多','职员',7698,'1981-12-03',950,null,30);
insert into emp values(7902,'大锦鲤','分析师',7566,'1981-12-03',

转载于:https://www.cnblogs.com/mojiangzz/p/11488072.html