Bulk insert into table with one single query

Question

Suppose i have one table [tblemployee]

i have one department = 21
i have one status = 3
i have value = 1,2,3,4
i have member = 21,22,32,45

i want one single query which will insert 4 record like

21 3 1 21

21 3 2 22

21 3 3 32

21 3 4 45

which mean department and status will be same for all row please help me

musiKk · Accepted Answer · 2011-08-09 12:45:31Z

4

Something like this?

INSERT INTO tblemployee(department, status, value, member)
VALUES(21, 3, 1, 21),(21, 3, 2, 22),(21, 3, 3, 32),(21, 3, 4, 45);

You can find more information for the INSERT syntax in the documentation (look for multirow).

answered Aug 9, 2011 at 10:03

musiKk

15.3k4 gold badges60 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nishant · Accepted Answer · 2015-06-10 12:28:11Z

0

Try something like this for your query

INSERT INTO MyTable (ID, Name)
SELECT 123, 'Timmy'
UNION ALL
SELECT 124, 'Jonny'
UNION ALL
SELECT 125, 'Sally'

answered Jun 10, 2015 at 12:28

Nishant

12.6k9 gold badges61 silver badges94 bronze badges

Way too complicated. A simple INSERT with multiple rows will do.