Insert multiple rows with one query MySQL

by 
 INSERT INTO table (a,b) VALUES (1,2), (2,3), (3,4);

http://dev.mysql.com/doc/refman/5.5/en/insert.html

More Related Contents:

  1. MySQL query won't update database [closed]
  2. Gather column name of a table from database [closed]
  3. PHP sending form data to the database
  4. Insert form in MySQL with PDO [duplicate]
  5. Is the following code valid? [closed]
  6. Undefined index $_POST
  7. How do I get the last inserted ID of a MySQL table in PHP?
  8. Getting raw SQL query string from PDO prepared statements
  9. SET NAMES utf8 in MySQL?
  10. How to get count of rows in MySQL table using PHP?
  11. “Invalid parameter number: parameter was not defined” Inserting data
  12. MySQL Prepared statements with a variable size variable list
  13. Fatal error: Call to undefined function mysql_connect()
  14. PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [duplicate]
  15. How can I properly use a PDO object for a parameterized SELECT query
  16. PDO::fetchAll vs. PDO::fetch in a loop
  17. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
  18. Comma separated values in MySQL “IN” clause
  19. MySQL Prepared Statements
  20. MySQL PHP incompatibility
  21. Set timezone in PHP and MySQL
  22. Doctrine – How to print out the real sql, not just the prepared statement?
  23. Getting a PHP PDO connection from a mysql_connect()?
  24. How can I debug why simplest MySQL query returns false?
  25. PHP to MySQL SSL Connections
  26. How to backup MySQL database in PHP?
  27. Auto Increment skipping numbers?
  28. PDO bindParam into one statement?
  29. Convert Time String to Decimal Hours PHP [closed]
  30. How to make mysqli connect function?

Leave a Comment