一条insert嘛, 如下:insert into table (field1,field2) select value11,value12 union select value21,value22 union select value31,value32 union select value41,value42 union select value51,value52
insert into table(field1,field2) values((values11,value12),(values21,values22),.....)
insert into table(field1,field2) values((values11,value12),(values21,values22),.....) 不可以,我在access中试过了
insert into tablename (field1,field2) (
table (value11,value12),
(value21,value22)
)
是我记错了么?还是 access 中不支持这样的语句?
select value11,value12 union
select value21,value22 union
select value31,value32 union
select value41,value42 union
select value51,value52