Страница 1 из 1

SQL запросы помощь

Добавлено: 10 май 2018 11:10
mokat
Добрый день! Не подскажите правильные запросы или нет.

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';;;

Re: SQL запросы помощь

Добавлено: 16 май 2018 11:37
TechAdmin
Правильные.