Shulou(Shulou.com)06/01 Report--

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' 2403600 BEGIN set% Ymurk% mmurf% d'); WHILE 1mm 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.