写法1:
insert into tableName (列名1,列名2,列名3,列名4) values (值1,值2, 值3, 值4),(值1,值2, 值3, 值4)......
写法2:
insert into tableName (列名1,列名2,列名3,列名4)
select 值1,值2,值3,值4,
union all select 值1,值2,值3,值4union all select 值1,值2,值3,值4......
写法1:
insert into tableName (列名1,列名2,列名3,列名4) values (值1,值2, 值3, 值4),(值1,值2, 值3, 值4)......
写法2:
insert into tableName (列名1,列名2,列名3,列名4)
select 值1,值2,值3,值4,
union all select 值1,值2,值3,值4union all select 值1,值2,值3,值4......