查看定时,开启定时
show variables like '%sche%';
set global event_scheduler =0;
获取当前系统时间
select now() as Systime;
select current_date as Systime;
select sysdate() as Systime;
BEGIN
SELECT * FROM user;
IF NOW()>'2016-08-10 09:00:17'
THEN
TRUNCATE TABLE xxx.aaa;
END IF;
END
CALL abcd()
show variables like '%sche%';
set global event_scheduler =0;
获取当前系统时间
select now() as Systime;
select current_date as Systime;
select sysdate() as Systime;
BEGIN
SELECT * FROM user;
IF NOW()>'2016-08-10 09:00:17'
THEN
TRUNCATE TABLE xxx.aaa;
END IF;
END
CALL abcd()