MySQL插入...值和选择 [英] MySQL INSERT INTO ... VALUES and SELECT

问题描述

有没有一种方法可以插入预设值和从选择查询中获得的值? 例如:

Is there a way to insert pre-set values and values I get from a select-query? For example:

INSERT INTO table1 VALUES ("A string", 5, [int]).

我具有字符串"的值和数字5，但是我必须从这样的选择中找到[int]值:

I have the value of "A string" and the number 5, but I've to find the [int] value from a select like this:

SELECT idTable2
FROM table2
WHERE ...

这让我可以将ID放在table1内.

that gives me that id to put inside table1.

如何将其合并为一条语句?

How to merge this into one statement?

推荐答案

使用insert ... select查询，并将已知值放入select:

Use an insert ... select query, and put the known values in the select:

insert into table1
select 'A string', 5, idTable2
from table2
where ...

这篇关于MySQL插入...值和选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！