SQL插入，带有选择值和硬编码值 [英] SQL insert with select and hard-coded values

问题描述

出于说明目的，假设我有一个电影数据库(标题，导演，成本，利润).

For illustration purposes, let's say I have a database Movies(Title, Director, Cost, Profits).

现在，我想根据在另一个表中找到的导演，然后再对值进行硬编码，将新行插入Movies表中.

Now I would like to insert a new row into the Movies table based on a director found in another table and then hard coded values.

INSERT INTO Movies 
SELECT name 
  FROM Directors 
 WHERE name = 'Lucas';

是我对select插入工作的理解，但是如果我想使用select并传递硬编码值，该怎么办.所以理论上是这样的:

Is how I understand select inserts work but what if I want to use the select as well as pass in hard coded values. So something theoretically like this:

INSERT INTO Movies 
VALUES(Star Wars,(SELECT name 
                    FROM Directors 
                   WHERE name='Lucas'), 50000, 1000000);

这可能吗?

推荐答案

INSERT INTO Movies (Title, Director, Cost, Profits)
SELECT 'Star Wars', name, 50000, 1000000
FROM Directors WHERE name = 'Lucas'

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