mysql动态查询插入，只需在db中一一插入即可

Question

我必须插入一些来自不同表的动态项目插入 (field1, field2, field3) 值( <select query fetching one record>,<static value>, <select query fetching multiple records, need to insert one by one> )

如何在数据库中使用foreach插入？请帮忙!

示例数据:插入 (field1, field2, field3) 值( select myname from table1',0, select payment[1] from table2 );插入 (field1, field2, field3) 值( select myname from table1',0, select payment[2] from table2 );

Answer 1

如果您要插入到表中的是其他查询的组合结果，您可以将 INSERT INTO 与 SELECT 和 UNION 一起使用。像这样的事情

INSERT INTO your_table (column1, column2, column3)
SELECT column1, column2, column3
FROM table1
UNION ALL
SELECT column1, column2, column3
FROM table2