PHP multiple MYSQL commands in one mysql_query() query

Question

I want to issue multiple mysql commands with one mysql_query function. This is my code:

$query .= "INSERT INTO `users` VALUES(1,'stack','overflow');";
$query .= "INSERT INTO `posts` VALUES('other','stack','overflow');";
mysql_query($query);

If I do that I get a warning that my syntax would be incorrect. If I echo the output, copy it and execute it in phpMyAdmin it works.

Where is the error there?

http://stackoverflow.com/questions/802437/how-to-execute-two-mysql-queries-as-one-in-php-mysql Perhaps duplicate? — Rey Gonzales, Jun 19 '12 at 18:06
See also [the documentation for `mysql_query`](http://php.net/manual/en/function.mysql-query.php): "sends a unique query (multiple queries are not supported)" — sczizzo, Jun 19 '12 at 18:08

score 4 · Answer 1 · answered Jun 19 '12 at 18:09

4

$query = "INSERT INTO `users` VALUES (1,'stack','overflow'), ('other','stack','overflow');";
mysql_query($query);

PHP does not support sending more than one query at a time via mysql_query, but you can achieve your result in a single one by using the above.

answered Jun 19 '12 at 18:09

Jay

3,285
1
20
19

3

That does not insert values into posts table. – bancer Sep 07 '14 at 21:51

score 2 · Answer 2 · answered Jun 19 '12 at 18:09

according to http://www.php.net/manual/en/function.mysql-query mysql_query() sends a unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier.

but this guy said that you just have to pass flag 65536 as mysql_connect's 5 parameter http://www.php.net/manual/en/function.mysql-query.php#91669

score 2 · Accepted Answer · answered Jun 19 '12 at 18:10

2

I think you need this?? http://us2.php.net/manual/en/mysqli.multi-query.php

answered Jun 19 '12 at 18:10

Don

863
1
8
22

Although in my experience, one query at a time is usually far simpler :) – Don Jun 19 '12 at 18:12
how is the performance with executing mysql_query() for each query? I have like 100s of queries to insert per pageload – Matthias Dunnowa Jun 19 '12 at 18:15
don't know about performance, you'd have to ask someone else for that; I incorrectly assumed this was a lower-scale project – Don Jun 19 '12 at 18:21
I went with mysqli solution, thanks – Matthias Dunnowa Jun 19 '12 at 18:47

PHP multiple MYSQL commands in one mysql_query() query

3 Answers3

Linked