Re: Updating a field in a stored procedure

[Peter Brawley]

That sproc looks fine, though, since it has just one line, Begin/End and Delimiter are not needed ...

DROP PROCEDURE IF EXISTS DuplicateProduct;
CREATE PROCEDURE DuplicateProduct()
UPDATE oc_product_description_temp SET product_id=(SELECT product_id FROM oc_product WHERE sku='sku19');