数据库练习（二）

Xinan_____

已于 2024-04-16 08:38:56 修改

阅读量859

点赞数 25

分类专栏： MySQL 文章标签：数据库

于 2024-04-13 01:45:38 首次发布

本文链接：https://blog.youkuaiyun.com/Xinan_____/article/details/137695666

版权

建表

create table employee(
 empno     int  primary key auto_increment ,     
 ename     char(10) ,  
 job       char(6)  ,  
 mgr       int      ,  
 hiredate  date     ,  
 sal       float(10,2),
 comm      float(10,2),
 deptno    int    );    

insert into employee(empno,ename,job,mgr,hiredate,sal,comm,deptno) values
('1001','甘宁','文员','1013','2000-12-17','8000.00',NULL,'20'),
('1002','黛绮丝','销售员','1006','2001-02-20','16000.00','3000.00','30'),
('1003','殷天正','销售员','1006','2001-02-22','12500.00','5000.00','30'),
('1004','刘备','经理','1009','2001-04-02','29750.00',NULL,'20'),
('1005','谢逊','销售员','1006','2001-09-28','12500.00','14000.00','30'),
('1006','关羽','经理','1009','2001-05-01','28500.00',NULL,'30'),
('1007','张飞','经理','1009','2001-09-01','24500.00',NULL,'10'),
('1008','诸葛亮','分析师','1004','2007-04-19','30000.00',NULL,'20'),
('1009','曾阿牛','董事长',NULL,'2001-11-17','50000.00',NULL,'10'),
('1010','韦一笑','销售员','1006','2001-09-08','15000.00&