急求！！！sql

最新推荐文章于 2024-09-15 23:28:35 发布

changge27

最新推荐文章于 2024-09-15 23:28:35 发布

阅读量501

点赞数

文章标签： insert null sql 360

本文链接：https://blog.csdn.net/changge27/article/details/5157918

版权

insert into departments values('1','财务部',NULL)
insert into departments values('2','人力资源部',NULL)
insert into departments values('3','经理办公室',NULL)
insert into departments values('4','研发部',NULL)
insert into departments values('5','市场部',NULL)
select * from departments;
insert into Employees values('000001','王林','1956-1-23',1,'中山路32-1-508','210003','3355668',NULL,2)
insert into Employees values('010008','伍容华','1966-3-28',1,'北京东路100-2','210001','3321321',NULL,1)
insert into Employees values('020010','王向容','1972-12-9',1,'四牌楼10-10-108','210006','3792361',NULL,1)
insert into Employees values('020018','李丽','1950-7-30',0,'虎距路100-2 ','210002','3413301','lili@sina.com',1)
insert into Employees values('102201','刘明','1962-10-18',1,'牌楼巷5-3-1806','210013','3606608',NULL,5)
insert into Employees values('102208','朱俊','1955-09-28',1,'中山路108-3-105','210004','4708817','zhujun@sina.com',5)
insert into Employees values('108991','钟敏','1969-08-10',0,'中山东路102-2','210003','3346722','zhongmin@sohu.com',3)
insert into Employees values('111006','张石兵','1964-10-01',1,'解放路34-9-1-203','210010','4563418','zhang@china.com',5)
insert into Employees values('210678','林涛','1967-04-02',1,'中山北路247-2-305','210008','3467336',NULL,3)
insert into Employees values('302566','李玉珉','1958-09-20',1,'热和路209-3','210018','8765991','liyumin@jlonline.com',4)
insert into Employees values('308759','叶凡','1968-11-18',1,'北京西路3-7-502','210001','3308901',NULL,4)
insert into Employees values('504209','陈林琳','1959-09-03',0,'汉中路120-4-102','210002','4468158',NULL,4)
select * from employees
insert into salary values ('000001',2100.8,123.09)
insert into salary values ('010008',1582.62,88.03)
insert into salary values ('102201',2569.88,185.65)
insert into salary values ('111006',1987.01,79.58)
insert into salary values ('504209',2066.15,108.0)
insert into salary values ('302566',2980.7,210.2)
insert into salary values ('108991',3259.98,281.52)
insert into salary values ('020010',2860.0,198.0)
insert into salary values ('020018',2347.68,180.0)
insert into salary values ('308759',2531.98,199.08)
insert into salary values ('210678',2240.0,121.0)
insert into salary values ('102208',1980.0,100.0)