Mysql: How to insert into table using select where

问题:

2 Works:

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

Works:

SELECT ID FROM data.table

How do I combine the above 2 statements using Mysql

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

回答1:

Are you possibly after something like this:

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