使用变量mysql从select语句中插入多行

Question

Here's the sql statement I tried for adding data from one table to another.

INSERT INTO wp_postmeta(`post_id`,`meta_key`,`meta_value`) VALUES((SELECT ID FROM wp_posts tb WHERE tb.post_type = 'support'),'category_order','0')

Basicaly I want to add rows to the wp_postmeta table. I want to add two static values, meta_key and meta_value. But I also want to add post_id which should be derived from the ID of each row in wp_posts. This doesn't seem to work when there are multiple rows returned from the SELECT statement.

Thanks for the help.

Answer 1

Try this instead

INSERT INTO wp_postmeta(post_id,meta_key,meta_value) SELECT ID, 'category_order','0' FROM wp_posts tb WHERE tb.post_type = 'support'