php mysql 批量insert_mysql批量插入数据方法

insert插入多条数据有二种方法一种是写多条insert 语句用";"号分割每条sql,一种是insert本身的多个value

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 INTO table (field1,field2,field3) VALUES ('a',"b","c"), ('a',"b","c"),('a',"b","c");

延伸阅读:

5招优化MySQL插入方法

insert 返回自增列

几个insert插入技巧

MySQL不能正常插入中文数据、SQLyog不能正常显示中文数据解决办法