Update Id_Carrier_Reference Using Sql

[simon76]

Hi, I am hoping that someone may be able to help me. I am trying to update the "Selected Carriers" in products by using SQL.

 

I have just set up three carriers which need to be "selected carriers" for all products as they cover different weights. 

 

I can update the selected carriers with one carrier (see below)

 

UPDATE ps_product_carrier SET id_carrier_reference=2 WHERE id_product=10

 

but I cannot work out the correct syntax for updating three carriers with a ID Carrier reference of "2", "26" and "29".

 

I thought it might be something like:

 

UPDATE ps_product_carrier SET id_carrier_reference='2', '26', '29' WHERE id_product=10

 

but this doesn't work.

 

Does anyone have any ideas.

 

Thanks

 

Simon

Edited February 20, 2016 by simon76 (see edit history)

[tuk66]

You need more records. Consider to use INSERT or REPLACE:

http://dev.mysql.com/doc/refman/5.7/en/replace.html

id_carrier_reference=2, id_product=10
id_carrier_reference=26, id_product=10
id_carrier_reference=29, id_product=10