sql批量安插

sql批量插入
mysql批量插入数据方法[align=center][/align]
[size=medium][/size]

insert插入多条数据有二种方法一种是写多条insert 语句用;号分割每条sql,一种是insert本身的多个value 1,写多条insert用;分割 这个很简单,;号是mysql执行sql的结束符,写多个insert用;号割就是让mysql执行多次而已.比如: insert into table (field1,field2,field3) values(....);

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

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"); phperz.com

2,在insert中写多个value
INSERT INTO table (field1,field2,field3) VALUES ('a',"b","c"), ('a',"b","c"),('a',"b","c");



本文来自PHP程序员站,转载请注明出处: http://www.phperz.com/database/MySQL/0PS60120113601.html#142386-tqq-79317-46320-b24eb6680f3dbe0b5821c81c1af9b58e