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);