Добрый день! Не подскажите правильные запросы или нет.
UPDATE oc_product AS p JOIN etrade_products_addon_fields AS e ON e.tov_id = p.product_id SET p.tyre_width = e.field_value WHERE e.field_name = '_50E0W6YA0';;;
UPDATE oc_product AS p JOIN etrade_products_addon_fields AS e ON e.tov_id = p.product_id SET p.tyre_profile = e.field_value WHERE e.field_name = '_50E0W6YA1';;;
UPDATE oc_product AS p JOIN etrade_products_addon_fields AS e ON e.tov_id = p.product_id SET p.tyre_diameter = e.field_value WHERE e.field_name = '_50E0W6Y9Z';;;
UPDATE oc_product AS p JOIN etrade_products_addon_fields AS e ON e.tov_id = p.product_id SET p.tyre_type = e.field_value WHERE e.field_name = '_51Q0U9XOU';;;
UPDATE oc_product AS p JOIN etrade_products_addon_fields AS e ON e.tov_id = p.product_id SET p.tyre_antiflat = e.field_value WHERE e.field_name = '_50H0WHE5C';;;
SQL запросы помощь
Правильные.
С уважением, поддержка ElbuzGroup.