MySQL:数据库练习题-1

表一：employees

USE yggl
SELECT * FROM employees
INSERT into employees VALUES
('102201','刘明','本科',19721018,1,3,'虎踞路100-2','83606608',5),
('102208','朱骏','硕士',19650928,1,2,'牌楼巷5-3-106','84708817',5),
('108991','钟敏','硕士',19790810,0,4,'中山路10-3-105','83346722',3),
('111006','张石兵','本科',19741001,1,1,'解放路34-1-203','84563418',5),
('210678','林涛','大专',19770402,1,2,'中山北路24-35','83467336',3),
('302566','李玉珉','本科',19680920,1,3,'热河路209-3','58765991',4),
('308759','叶凡','本科',19781118,1,2,'北京西路3-7-52','83308901',4),
('504209','陈林琳','大专',19690903,0,5,'汉中路120-4-12','84468158',4)

表二：salary

SELECT * FROM salary
INSERT into salary VALUES
('000001',2100.8,123.09),
('010008',1582.62,88.03),
('020010',2860,198),
('020018',2347.68,180),
('102201',2569.88,185.65),
('102208',1980,100),
('108991',3259.98,281.52),
('111006',1987.01,79.58),
('210678',2240,121),
('302566',2980.7,210.2),
('308759',2531.98,199.08),
('504209',2066.15,108)

表三：departments

 
SELECT * FROM departments
INSERT into departments VALUES
(1,"财务部",NULL),
(2,"人力资源部",NULL),
(3,"经理办公室",NULL),
(4,"研发部",NULL),
(5,"市场部",NULL)