science-ation/db/db.update.102.sql

5 lines
149 B
MySQL
Raw Permalink Normal View History

SELECT @id:=id FROM reports WHERE system_report_id='44';
UPDATE reports_items SET `value`='letter_4up' WHERE `field`='stock' AND `reports_id`=@id;