Multiple MySQL Queries
| From: | Uttam | Date: | Sat, 01 Feb 2003 10:16:14 +0000 |
| Subject: | Multiple MySQL Queries | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-18286@lists.php.net to get a copy of this message | ||
in MySQL client i can run multiple queries in a single statement like:
"CREATE TEMPORARY TABLE x (a CHAR(6), b FLOAT(12,4)); INSERT INTO x SELECT
a, sum(*blah*)..FROM y ; SELECT * FROM x INNER JOIN z ....;"
but in PHP ";" is not allowed in function mysql_query().
Is there some workaround for running the above query in PHP in a SINGLE
mysql_query() call?
thanx!