数据库操作之事件
delimiter // DROP EVENT IF EXISTS event_clearclient_daily; CREATE EVENT event_clearclient_daily ON SCHEDULE EVERY 1 DAY STARTS '2016-09-22 02:00:00' ENABLE DO BEGIN select pro_clients(); END delimiter // CREATE DEFINER = ``@`` FUNCTION `pro_clients`() RETURNS int(11) BEGIN set @now=from_unixtime(unix_timestamp(now())-10*24*3600,'%Y-%m-%d'); WHILE 1=1 do set @lasttime=(select acctTIme from client_data where left(acctTime,10)=@now limit 1); if @lasttime != '' then delete from client_data where left(acctTime,10)=@now limit 1; else RETURN 0; end if; END WHILE; END;
分享题目:数据库操作之事件
本文网址:http://azwzsj.com/article/jhggpe.html