Cacher is the code snippet organizer for pro developers

-- изменение количества товара с 1 до 100
UPDATE `oc_product` SET `quantity` = REPLACE(`quantity`, "1", "100");

-- включение опции с id 7
INSERT IGNORE `oc_product_option` (`product_id`, `option_id`, `value`,`required`)
SELECT `product_id`, 7, '', 0
FROM `oc_product`