向仓库表中插入下列数据: wh1,北京,370 wh2,上海,500 wh3,广州,200 wh4,武汉,400 wh5,南京,600 使用insert语句插入: insert into 仓库 values('wh1','北京','370'), ('wh2','上海','500'), ('wh3','广州','200'), ('wh4','武汉','400'), ('wh5','南京','600'); 向职工表插入下列数据: wh2,e1,1220 wh4,e2,1270 wh1,e3,1510 wh2,e4,1250 wh3,e5,1700 wh3,e6,1230 wh1,e7,1250 使用insert语句插入: insert into 职工 values('wh2','e1','1220'), ('wh4','e2','1270'), ('wh1','e3','1510'), ('wh2','e4','1250'), ('wh3','e5','1700'), ('wh3','e6','1230'), ('wh1','e7','1250'); 将所有职工工资加1000 update 职工 set 工资=工资+1000 将仓库号为“wh3”的职工工资加500 update 职工 set 工资=工资+500 where 仓库号='wh3' 将广州仓库的职工工资提高10% update 职工 set 工资=工资*1.1 where 仓库号='wh3' 将职工e1经手的订购单的订购日期改成20130101 update 职工 set 订购日期='20130101' where 职工号='e1' 删除订购单号or76的信息 delete from 订购单 where 订购单号='or76' 删除职工e6经手的订购单信息 delete from 订购单 where 职工号='e6'