insert into t (c1, c2, c3) values (1, 1, 1), (2, 2, 2)
insert into t (c1, c2, c3) (select a1, a2, a3) union all (select b1, b2, b3)
insert into t (c1, c2, c3) (select a1, a2, a3 from t2)
sql - 批量插入数据,布布扣,bubuko.com
sql - 批量插入数据
原文：http://www.cnblogs.com/sunlb/p/3841035.html
