insert all into JK_TB_DATE(fbmmc,fgzjh,fsbmc,fsbxh,fsbbh,db_shuifenyi,db_pihao,db_wuliaobianma)
values ('检测督查科','102','水分测试仪','SDWE-BZDHX-15','hx001','1#水分仪','11','')
into JK_TB_DATE (fbmmc,fgzjh,fsbmc,fsbxh,fsbbh,db_shuifenyi,db_pihao,db_wuliaobianma)
values ('检测督查科','102','水分测试仪','SDWE-BZDHX-10','hx002','2#水分仪','22','')
into JK_TB_DATE (fbmmc,fgzjh,fsbmc,fsbxh,fsbbh,db_shuifenyi,db_pihao,db_wuliaobianma)
values ('检测督查科','102','水分测试仪','SDWE-BZDHX-25','hx003','3#水分仪','33','')
select 1 from dual
注意:
1.第一句用的是insert all into 不是 insert into
2.最后跟的selecr 1 from dual语句中的dual表可以被替换为任何一个只要不是tb_red的表,dual是虚拟表
3.和mysql的写法不一样,多个values之间不用逗号分隔,但是需要加into tablename的形式的语句在每个values前面
也可以不指定列,直接按顺序输入值:
insert all into JK_TB_DATE values ('检测督查科','102','水分测试仪','SDWE-BZDHX-15','hx001','1#水分仪','11','')
into JK_TB_DATE values ('检测督查科','102','水分测试仪','SDWE-BZDHX-10','hx002','2#水分仪','22','')
into JK_TB_DATE values ('检测督查科','102','水分测试仪','SDWE-BZDHX-25','hx003','3#水分仪','33','')
select 1 from dual