MySQL:如何使用select where子句插入表中 [英] Mysql: How to insert into table using select where clause

问题描述

2个作品:

INSERT INTO data._top 
SELECT * FROM data.ops
WHERE ID = 'foo'

作品:

SELECT ID FROM data.table

如何使用Mysql结合上述2条语句

How do I combine the above 2 statements using Mysql

INSERT INTO data._top 
SELECT  * FROM   data.ops
WHERE     (SELECT ID FROM data.table)

推荐答案

您是否可能会遇到类似这样的事情:

Are you possibly after something like this:

INSERT INTO `data._top`
    SELECT * FROM `data.ops`
    WHERE `id` IN (SELECT `id` FROM `data.table`);

这篇关于MySQL:如何使用select where子句插入表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！