Mysql query insert from another table [duplicate]

Question

When using the query below I'm inserting product_id and I also want to set field category_id = 4 for all inserted product_ids. Here's my code to insert products.

INSERT INTO lc_products_to_categories
( product_id)
SELECT product_id
FROM lc_products_info
where name like '%awesome product%'

How to update category_id with single query?

just select the constant like this NSERT INTO lc_products_to_categories ( product_id,category_id) product_id, 4 FROM lc_products_info where name like '%awesome product%' — JYoThI
– JYoThI, Commented Jul 6, 2017 at 9:51

Philipp Sander · Accepted Answer · 2017-07-06 09:50:53Z

0

INSERT INTO lc_products_to_categories
( product_id, category_id)
SELECT product_id, 4
FROM lc_products_info
where name like '%awesome product%'

answered Jul 6, 2017 at 9:50

Philipp Sander

10.3k7 gold badges49 silver badges80 bronze badges

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

Collectives™ on Stack Overflow

Mysql query insert from another table [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related