How to execute two mysql queries as one in PHP/MYSQL?

by

Update: Apparently possible by passing a flag to mysql_connect(). See Executing multiple SQL queries in one statement with PHP Nevertheless, any current reader should avoid using the mysql_-class of functions and prefer PDO.

You can’t do that using the regular mysql-api in PHP. Just execute two queries. The second one will be so fast that it won’t matter. This is a typical example of micro optimization. Don’t worry about it.

For the record, it can be done using mysqli and the mysqli_multi_query-function.

More Related Contents:

  1. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  2. Php date() Date and time is stuck [closed]
  3. mysqli or die, does it have to die?
  4. MySQL vs MySQLi when using PHP [closed]
  5. PHP/MySQL insert row then get ‘id’
  6. How do I set ORDER BY params using prepared PDO statement?
  7. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  8. Using a .php file to generate a MySQL dump
  9. Insert Blobs in MySql databases with php
  10. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in [duplicate]
  11. PDO with INSERT INTO through prepared statements [closed]
  12. How do I execute PHP that is stored in a MySQL database?
  13. MySQL returns only one row
  14. Why doesn’t MySQL support millisecond / microsecond precision?
  15. Populate a Drop down box from a mySQL table in PHP
  16. PHP PDO vs normal mysql_connect
  17. How to sort rows of HTML table that are called from MySQL
  18. Doing a while / loop to get 10 random results
  19. php file upload, how to restrict file upload type
  20. MySQL Error “Too many connections”
  21. Warning: mysql_num_rows() expects parameter 1 to be resource, object given [duplicate]
  22. MySQL error when inserting data containing apostrophes (single quotes)?
  23. Connect to remote MySQL server with SSL from PHP
  24. MySQL query using an array [duplicate]
  25. Using MySQL’s TIMESTAMP vs storing timestamps directly
  26. Using Prepared Statement, how I return the id of the inserted row?
  27. Replacing \r\n with PHP
  28. How to check if a value already exists to avoid duplicates?
  29. How to use MySQL Found_Rows() in PHP?
  30. PHP loop; how to print each result and delay it for a second before echoing another result?

Leave a Comment