mysql - 如何在MySQL中进行批量插入

Question

我有1-多条记录需要输入到表中。在查询中执行此操作的最佳方法是什么？我应该创建一个循环并每次迭代插入一条记录吗？或者有更好的办法吗？

Answer 1

来自MySQL manual

INSERT statements that use VALUES syntax can insert multiple rows. To do this, include multiple lists of column values, each enclosed within parentheses and separated by commas. Example:

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);