MySQL SELECT из одной таблицы и UPDATE другой

[Heidel]

http://stackoverflow.com/questions/37069551/mysql-add-data-from-one-table-to-another

uc_products
----------------------------
vid
sell_price

uc_product_options
----------------------------
nid
oid
price

UPDATE uc_products a 
    JOIN uc_product_options b ON a.vid = b.nid 
SET a.sell_price = b.price
where b.oid=3

UPDATE `uc_products` SET sell_price = 0.0;

@темы: MySQL, Ссылки