MySql 多重插入与选择

Question

我正在尝试使用 select 插入多行，如下所示:

INSERT INTO Check(
name, price, 
count, order_id) 
SELECT 
p.name, p.price, 
:count, :order 
FROM Product p 
WHERE p.id 
IN(:id1, :id2, :id3)

问题是每个 :id1, :id2, ... 都有自己的 :coun1, :count2, :count3。

Answer 1

你在找这样的东西吗？:

INSERT INTO Check(
name, price, 
count, order_id) 
SELECT 
p.name, p.price, 
IF (id = :id1, :count1, IF (id = :id2, :count2, :count3)), :order 
FROM Product p 
WHERE p.id 
IN(:id1, :id2, :id3)