Categories
Uncategorized

Maintenance MySQL – Stock Report Android: stock_record_current_day

CREATE VIEW stock_record_current_day AS
SELECT * FROM stock_record
WHERE
stock_record.sr_ts >=DATE_SUB(now(), INTERVAL 1 DAY);

Leave a Reply

Your email address will not be published. Required fields are marked *