数据库操作之事件

delimiter //DROP EVENT IF EXISTS event_clearclient_daily;CREATE EVENT event_clearclient_dailyON SCHEDULE EVERY 1 DAYSTARTS '2016-09-22 02:00:00'ENABLEDOBEGINselect pro_clients();ENDdelimiter //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;