Mysql Stored Procedure
Hi,
I need to have a stored procedure created where I take, on 15 minute intervals, data from a couple of tables and run them through a small formula, and update a series of records with the result.
Specifics are that two pricing tables (silver and gold) get a price update on 15 minute intervals, and those prices are “cleansed” and then applied to the relevant product records (those that are marked as either au or ag).
Thanks.