Ian McCullough Ian McCullough - 1 year ago 86
MySQL Question

Multiple mysql INSERT statements in one query php

Is this legal?

$string1= "INSERT INTO....;";
$string1 .= "INSERT INTO....;";
$string1 .= "INSERT INTO....;";
mysql_query($string1) or die(mysql_error());

Answer Source

For what it's worth, and depending on if you're inserting the same data into the same tables, it's much better to insert multiple values with the one insert e.g.

INSERT INTO a VALUES (1,23),(2,34),(4,33);
INSERT INTO a VALUES (8,26),(6,29);
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download