要求:每天凌晨执行,删除前天的数据(例:11月5号凌晨删除1,2,3号的数据,保留11月4号的数据)
操作表表名Temp 表有id,num,cost,buytime等几列数据,其中buytime是时间标示列触发器的格式也不会写。。获取前天的时间也不会写。。求高手补全create procedure `del_temp`()
begin delete * from temp where buytime < (昨天零时不会写...);end;
操作表表名Temp 表有id,num,cost,buytime等几列数据,其中buytime是时间标示列触发器的格式也不会写。。获取前天的时间也不会写。。求高手补全create procedure `del_temp`()
begin delete * from temp where buytime < (昨天零时不会写...);end;
昨天select now()-interval 1 day;
SET GLOBAL event_scheduler = 1;
or
SET GLOBAL event_scheduler = ON;CREATE EVENT e_test ON SCHEDULE EVERY 24 HOUR
STARTS concat(date_format(now(),'%Y-%m-%d'),' 00:00:00') DO
delete * from temp where buytime<now()-interval 2 day
on schedule every 1 day starts '2010-11-01 11:02:00'
do
delete from asd where dy < date_sub(curdate(),interval 1 day)
set global event_scheduler = 1;DROP EVENT IF EXISTS e_test;
CREATE EVENT e_test
ON SCHEDULE AT '2010-10-31 00:00:00' +INTERVAL 1 DAY
on completion not preserve
do
delete from Tab where bytime < now()-interval 3 day;
定时执行mysql数据库任务方案。