一次查询即可批量插入表格 [英] Bulk insert into table with one single query

问题描述

假设我有一张桌子[tblemployee]

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

我想要一个查询，该查询将插入4条记录，例如

i want one single query which will insert 4 record like

21 3 1 21

21 3 1 21

21 3 2 22

21 3 2 22

21 3 3 32

21 3 3 32

21 3 4 45

21 3 4 45

这意味着所有行
的部门和状态都将相同

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

推荐答案

是这样吗？

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

您可以在文档（查找 multirow ）。

这篇关于一次查询即可批量插入表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！