使用insert ... select
查询,并将已知值放入select
:
insert into table1
select 'A string', 5, idTable2
from table2
where ...
MySQL插入...值和选择
使用insert ... select
查询,并将已知值放入select
:
insert into table1
select 'A string', 5, idTable2
from table2
where ...