How Can I Optimize Multiple MySQL INSERT Statements in PHP?

Using Multiple Concurrent MySQL INSERT Statements in PHP

This technique allows you to perform multiple INSERT operations within a single MySQL query. Consider the following example:

$string1 = "INSERT INTO mytable1 (id, name) VALUES (1, 'John');";
$string1 .= "INSERT INTO mytable2 (id, name) VALUES (2, 'Mary');";
$string1 .= "INSERT INTO mytable3 (id, name) VALUES (3, 'Bob');";
mysql_query($string1) or die(mysql_error());

While this method may seem convenient, it is generally not advisable for performance reasons. However, in specific scenarios where it might be necessary, it's worth considering an alternative approach.

Optimized Multi-Value Insertion

For improved performance, it's recommended to insert multiple values using a single INSERT statement. This can significantly reduce overhead and improve efficiency, as demonstrated in the following example:

$query = "INSERT INTO mytable (id, name) VALUES ";
$query .= "(1, 'John'), (2, 'Mary'), (3, 'Bob');";
mysql_query($query) or die(mysql_error());

The above is the detailed content of How Can I Optimize Multiple MySQL INSERT Statements in PHP?. For more information, please follow other related articles on the PHP Chinese website!