SQL_电力抢修工程插入数据语句_电力项目使用的sql操作-CSDN博客

本文链接：https://blog.csdn.net/FlushHip/article/details/52097949

本文记录了多个电力抢修项目的详细信息，包括项目编号、名称、开始与结束时间及状态，并跟踪了用于抢修作业的材料库存情况，涵盖了不同规格的电线、电缆等材料的库存数量。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

代码：

--salvaging
insert into salvaging(prj_num,prj_name,start_date,end_date,prj_status) 
    values('20100015','220KV清经线接地箱及接地线被盗抢修','10/12/2010 00:00:00','10/13/2010 00:00:00',1);
insert into salvaging(prj_num,prj_name,start_date,end_date,prj_status) 
    values('20100016','沙河站2#公变出线电缆老化烧毁抢修','11/05/2010 00:00:00','11/06/2010 00:00:00',1);
insert into salvaging(prj_num,prj_name,start_date,end_date,prj_status) 
    values('20100001','西丽站电缆短路烧毁抢修工程','01/03/2011 00:00:00','01/04/2011 00:00:00',1);
insert into salvaging(prj_num,prj_name,start_date,end_date,prj_status) 
    values('20100002','西丽站电缆接地抢修','01/03/2011 00:00:00','01/05/2011 00:00:00',1);
insert into salvaging(prj_num,prj_name,start_date,end_date,prj_status) 
    values('20100003','观澜站光缆抢修','02/10/2011 00:00:00','02/11/2011 00:00:00',1);
insert into salvaging(prj_num,prj_name,start_date,end_date,prj_status) 
    values('20100004','小径墩低压线被盗抢修','02/15/2011 00:00:00','02/17/2011 00:00:00',1);
insert into salvaging(prj_num,prj_name,start_date,end_date,prj_status) 
    values('20100005','明珠立交电缆沟盖板破损抢修','03/02/2011 00:00:00','02/05/2011 00:00:00',0);
insert into salvaging(prj_num,prj_name,start_date,end_date,prj_status) 
    values('20100006','朝阳围公变低压线被盗抢修','03/08/2011 00:00:00','03/10/2011 00:00:00',0);

--stock
insert into stock(mat_num,mat_name,speci,warehouse,amount,unit) 
    values('m001','护套绝缘电线','BVV-120','供电局1#仓库',220,89.80);
insert into stock(mat_num,mat_name,speci,warehouse,amount,unit) 
    values('m002','架空绝缘导线','10KV-150','供电局1#仓库',30,17.00);
insert into stock(mat_num,mat_name,speci,warehouse,amount,unit) 
    values('m003','护套绝缘电线','BVV-35','供电局2#仓库',80,22.80);
insert into stock(mat_num,mat_name,speci,warehouse,amount,unit) 
    values('m004','护套绝缘电线','BVV-50','供电局2#仓库',283,32.00);
insert into stock(mat_num,mat_name,speci,warehouse,amount,unit) 
    values('m005','护套绝缘电线','BVV-70','供电局2#仓库',130,40.00);
insert into stock(mat_num,mat_name,speci,warehouse,amount,unit) 
    values('m006','护套绝缘电线','BVV-150','供电局3#仓库',46,85.00);
insert into stock(mat_num,mat_name,speci,warehouse,amount,unit) 
    values('m007','架空绝缘导线','10KV-120','供电局3#仓库',85,14.08);
insert into stock(mat_num,mat_name,speci,warehouse,amount,unit) 
    values('m008','护套绝缘电线','BVV-120','供电局3#仓库',164,88.00);
insert into stock(mat_num,mat_name,speci,warehouse,amount,unit) 
    values('m009','交联聚乙烯绝缘电缆','YJV22-15KV','供电局4#仓库',45,719.00);
insert into stock(mat_num,mat_name,speci,warehouse,amount,unit) 
    values('m010','户外真空断路器','ZW12-12','供电局4#仓库',1,13600.00);

--out_stock
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100015','m001',2,'10/12/2010 00:00:00','工程1部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100015','m002',1,'10/12/2010 00:00:00','工程1部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100016','m001',3,'11/05/2010 00:00:00','工程1部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100016','m003',10,'11/05/2010 00:00:00','工程1部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100001','m001',2,'01/03/2011 00:00:00','工程2部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100002','m001',1,'01/03/2011 00:00:00','工程2部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100002','m009',1,'01/03/2011 00:00:00','工程2部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100003','m001',5,'02/11/2011 00:00:00','工程3部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100003','m010',1,'02/11/2011 00:00:00','工程3部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100004','m001',3,'02/15/2011 00:00:00','工程3部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100004','m004',20,'02/15/2011 00:00:00','工程3部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100005','m001',2,'03/02/2011 00:00:00','工程2部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100005','m003',10,'03/02/2011 00:00:00','工程2部');
insert into out_stock(prj_num,mat_num,amount,get_date,department) 
    values('20100005','m006',3,'03/02/2011 00:00:00','工程2部');