From the MySQL manual
INSERT statements that use VALUES syntax can insert multiple rows. To do this, include multiple lists of column values, each enclosed within parentheses and separated by commas. Example:
INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);
Related Posts:
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- How do I restore a dump file from mysqldump?
- 1052: Column ‘id’ in field list is ambiguous
- 1052: Column ‘id’ in field list is ambiguous
- difference between primary key and unique key
- SQL – IF EXISTS UPDATE ELSE INSERT INTO
- Error: Duplicate entry ‘0’ for key ‘PRIMARY’
- Case statement in MySQL
- “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
- Cannot delete or update a parent row: a foreign key constraint fails
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- How do I quickly rename a MySQL database (change schema name)?
- What does SQL Select symbol || mean?
- What is the definition of cardinality in SQL
- When to use SELECT … FOR UPDATE?
- Error Code: 2013. Lost connection to MySQL server during query
- How to join two tables by multiple columns in SQL?
- How to get size of mysql database?
- mysql Foreign key constraint is incorrectly formed error
- Selecting data from two different tables without using joins
- how to drop partition without dropping data in MySQL?
- MySQL: Invalid use of group function
- Creating a search form in PHP to search a database?
- Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
- MySQL Error 1264: out of range value for column
- Simple Random Samples from a Sql database
- ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
- What does SQL clause “GROUP BY 1” mean?
- LAST_INSERT_ID() MySQL
- Generating a random & unique 8 character string using MySQL
- SQL select only rows with max value on a column
- SQL statement not working – “Operand type clash: date is incompatible with int’
- Convert partially non-numeric text into number in MySQL query
- Repair all tables in one go
- MySQL equivalent of DECODE function in Oracle
- How can I search (case-insensitive) in a column using LIKE wildcard?
- How to create a foreign key in phpmyadmin
- Get the new record primary key ID from MySQL insert query?
- importing a CSV into phpmyadmin
- How to copy a row and insert in same table with a autoincrement field in MySQL?
- ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
- Solutions for INSERT OR UPDATE on SQL Server
- Remove Primary Key in MySQL
- MySQL: Cloning a MySQL database on the same MySql instance
- Is merge statement available in MySQL
- What SQL Query to do a simple find and replace
- What’s a good strategy for planning WordPress DB growth?
- Scanning Database for malicious Data
- wpdb->prepare function remove single quote for %s in SQL statment
- How to Join two tables from separate databases within WordPress
- Extending the database
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- How to execute mulitple statement SQL queries using $wpdb->query?
- Query WordPress database by registered date and role
- wpdb_prepare with multiple or condition
- How do I find which articles are missing a featured image in The WordPress database?
- SQL Error wp_commentmeta – incorrect table definition
- How to find meta entries with their posts missing via SQL?
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- How do I get the posts within a certain year/date(with sql query)?
- Database Tables Lost Indexes? How to Recover?
- SQL Database, repeated tables?
- Create table from array with prepare
- Code to remove authors with no posts connected to them
- Which is better and faster ? WordPress Queries or SQL Query
- SQL Query in WordPress – Getting Impossible WHERE error
- Why this query is not showing any result on wordpresss home page?
- Using AND and bracket grouping in SQL not working
- How to get INSERT errors from $wpdb?
- SQL query to set posts in bulk based on the post content
- MySQL query for taxonomy-meta
- How can I write a formal sql query to get data from a custom table
- latency problems with wordpress install (from SQL import)
- DB prefix not updating
- Performing CRUD operations on front end in wordpress
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- Find locations of all featured images of draft posts via SQL
- SQL query to change custom field in WordPress database
- Bulk find & replace on WordPress posts/pages (minus image paths)
- How to show result of sql query in a page?
- update_option returns false in AJAX, how to debug?
- How to create index (sql) to a meta_key?
- Improving performance of SQL sub-queries in WordPress
- The function is deprecated; use mysql_real_escape_string() instead
- The MySQL Connection could not be established., before it was joomla but i have change it into worpress
- WPDB delivers wrong results from complex queries
- How to change link in all posts?
- Display MySQL as part of a Page
- Query sql for truncate post_content in wp_posts table
- Woocommerce: Grab total revenue of a product over all orders
- Migrated to Namecheap, now Trouble with Database & wp-config [closed]
- Delete posts with word count less than x number of words
- SQL query : Select a thumbnail for a media
- SQL – Pull products of particular category from a remote WordPress woocommerce db
- SQL command to export post_content from wp_posts using phpMyAdmin
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
- SQL get last entry of a specific gravity form
- Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
- Possible SQL injection. How to locate and fix?