Insert multiple rows from select statement with variable mysql

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.

@PatrickQ this doesn't make sense. These fields do not all exist in the wp_posts table. Only ID does. — mpn
– mpn, Commented Nov 10, 2014 at 18:08

w43L · Accepted Answer · 2014-11-10 18:08:15Z

2

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'

answered Nov 10, 2014 at 18:08

w43L

5651 gold badge8 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jherran · Accepted Answer · 2014-11-10 18:08:24Z

0

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

answered Nov 10, 2014 at 18:08

jherran

3,3878 gold badges39 silver badges54 bronze badges

Collectives™ on Stack Overflow

Insert multiple rows from select statement with variable mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related