Is it possible to insert the same values at once (Mysql)?

2018-07-03 22:13:36

This question already has an answer here:

Inserting multiple rows in a single SQL query? [duplicate] 4 answers

INSERT INTO Example (column_name) VALUES ('Red'),('Black'),('Green');

Yes you can do this, but your format is off.

INSERT INTO `Example` (`color`)
VALUES
('Red'),
('Black'),
('Green')

Each row must be separated by a comma with values for the row in parenthesis.

这是另一种适用于任何数据库的方式。

insert into example
select 'Red'
from SomeSmallTable
union
select 'Blue'
from SomeSmallTable
union
select 'Green'
from SomeSmallTable

链接地址: http://www.djcxy.com/p/94494.html