mysql 批量插入

/* 1,写多条insert用";"分割,注意一定要有“;”隔开,一开始没用,老是出错
这个很简单,;号是mysql执行sql的结束符,写多个insert用;号割就是让mysql执行多次而已.比如: */
insert into table (field1,field2,field3) value ('a',"b","c");
insert into table (field1,field2,field3) value ('a',"b","c");
insert into table (field1,field2,field3) value ('a',"b","c");
insert into table (field1,field2,field3) value ('a',"b","c");
insert into table (field1,field2,field3) value ('a',"b","c");

/* 2,在insert中写多个value,前面的insert语句可省略 */
INSERT INTO table (field1,field2,field3) VALUES ('a',"b","c"), ('a',"b","c"),('a',"b","c");

  

posted @ 2016-12-07 17:56  风在山路吹  阅读(117)  评论(0编辑  收藏  举报