php - 如何使用 mysql 在 php 中使用单个插入命令自动转到下一行并插入多行

Question

我已经看到与此问题相关的其他帖子，但他们没有解决我的问题。我想自动转到下一行并希望将该行插入表中。我正在从另一个数据库传输数据样本。我想插入大量行...现在我在所有行中重复获取第一行。我需要自动转到下一行

下面是我的示例代码...

while ($row = mysql_fetch_array($query)) {
    $sql = "INSERT INTO table_name (info1, info2, info3,...) " 
          ."VALUES (" . $row['info1'] . "," . $row['info2'] . "," . $row['info3'] . "),  
                   (" . $row['info1'] . "," . $row['info2'] . "," . $row['info3'] . "),  
                   (" . $row['info1'] . "," . $row['info2'] . "," . $row['info3'] . "),  
                   (" . $row['info1'] . "," . $row['info2'] . "," . $row['info3'] . ")";
}  

Answer 1

这个sql查询可以帮助你。您可以在一个查询中插入选择的数据。请参阅 MySQL 文档:http://dev.mysql.com/doc/refman/5.7/en/insert-select.html

INSERT INTO table_name 
    (info1, info2, info3)
SELECT 
    source_table.info1,
    source_table.info2,
    source_table.info3, 
FROM 
    source_table 
WHERE 
    (WHERE CLAUSE)