CODEWITHSUNDEEP
mysqlinsert
Merlin
Merlin

Reputation: 25699

Mysql: How to insert into table using select where clause

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)

Upvotes: 0

Views: 8075

Answers (1)

Milad Naseri
Milad Naseri

Reputation: 4118

Are you possibly after something like this:

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

Upvotes: 1

Related Questions