Mirgorod
Reputation: 32733
How to insert many items in one SQL query?
I have 20 items. Is it possible to insert 20 items only with one query (without loops)?
Upvotes: 0
Views: 162
Answers (2)
Dave Kiss
Reputation: 10495
INSERT into `table` (`1`,`2`,`3`....`20`) VALUES (`value1`,`value2`,`value3`,...`value20`)
Upvotes: 0
JYelton
Reputation: 36546
Look into syntax like this:
INSERT INTO table (column) VALUES (item1), (item2), (item3), ...
Upvotes: 7
Related Questions
- SQL Query to INSERT multiple rows with SELECT
- Inserting multiple rows in mysql
- Insert Select Multiple rows
- Insert multiple rows with one query MySQL
- MySQL - How can I insert multiple rows using select statement?
- how do i insert many values in a column in single query?
- Inserting multiple rows in 1 query mysql
- Multiple inserts with query
- MySql insert with multiple values in a single query
- How to insert multiple rows in single insert statement?