在SQL Server中，可以使用insert将行插入到表中。。SELECT语句：
INSERT INTO Table (col1, col2, col3)
SELECT col1, col2, col3
FROM other_table
WHERE sql = 'cool'
是否也可以使用SELECT更新表？我有一个包含这些值的临时表，并希望使用这些值更新另一个表。也许是这样的：
UPDATE Table SET col1, col2
SELECT col1, col2
FROM other_table
WHERE sql = 'cool'
WHERE Table.id = other_table.id
当前回答
UPDATE YourTable
SET Col1 = OtherTable.Col1,
Col2 = OtherTable.Col2
FROM (
SELECT ID, Col1, Col2
FROM other_table) AS OtherTable
WHERE
OtherTable.ID = YourTable.ID
其他回答
单向
UPDATE t
SET t.col1 = o.col1,
t.col2 = o.col2
FROM
other_table o
JOIN
t ON t.id = o.id
WHERE
o.sql = 'cool'
对于记录（以及其他像我一样的搜索），您可以在MySQL中这样做：
UPDATE first_table, second_table
SET first_table.color = second_table.color
WHERE first_table.id = second_table.foreign_id
我以前使用过INSERT SELECT。对于那些想使用新东西的人来说，这里有一个类似的解决方案，但它要短得多：
UPDATE table1 // Table that's going to be updated.
LEFT JOIN // Type of join.
table2 AS tb2 // Second table and rename for easy.
ON
tb2.filedToMatchTables = table1.fieldToMatchTables // Fields to connect both tables.
SET
fieldFromTable1 = tb2.fieldFromTable2; // Field to be updated on table1.
field1FromTable1 = tb2.field1FromTable2, // This is in the case you need to
field1FromTable1 = tb2.field1FromTable2, // update more than one field.
field1FromTable1 = tb2.field1FromTable2; // Remember to put ; at the end.
通过CTE进行更新比此处的其他答案更具可读性：
;WITH cte
AS (SELECT col1,col2,id
FROM other_table
WHERE sql = 'cool')
UPDATE A
SET A.col1 = B.col1,
A.col2 = B.col2
FROM table A
INNER JOIN cte B
ON A.id = B.id
使用别名：
UPDATE t
SET t.col1 = o.col1
FROM table1 AS t
INNER JOIN
table2 AS o
ON t.id = o.id
