Multiple mysql INSERT statements in one query php [duplicate]

by

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);

More Related Contents:

  1. How to create this type of JSON data from PHP [closed]
  2. Just using mysql real escape string [closed]
  3. Create hyperlink from html table row to open record on a new page
  4. Many-to-many relationships examples
  5. SELECT COUNT(*) AS count – How to use this count
  6. How to execute two mysql queries as one in PHP/MYSQL?
  7. Storing files in database Vs file system
  8. How to upload images into MySQL database using PHP code
  9. selecting unique values from a column
  10. MySQL Join two tables with comma separated values
  11. how safe are PDO prepared statements
  12. How to join three table by laravel eloquent model
  13. Secure files for download
  14. How to connect to MySQL database in PHP using mysqli extension?
  15. MySQL – Access denied for user [duplicate]
  16. Calling stored procedure with Out parameter using PDO
  17. When *not* to use prepared statements?
  18. org.json.JSONException: Value
  19. PHP Check for NULL
  20. How to display an BLOB image stored in MySql database?
  21. How to bind LIKE values using the PDO extension?
  22. How do I set the selected item in a drop down box
  23. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  24. WordPress Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1570
  25. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  26. PHP 7 RC3: How to install missing MySQL PDO
  27. PHP MySQL pagination with random ordering
  28. How do I save PHP session data to a database instead of in the file system?
  29. MySQL, how to insert null dates
  30. Escaping SQL queries in Codeigniter

Leave a Comment