close
1.
show events
2.
select @@event_scheduler
看是On還off
set global event_scheduler =on
3.刪除
delete from mysql.`event` where db='date_girl' and name='time_record'
4.
每十秒輸出現在時間
create event if not exists time_record
on schedule every 10 second
on completion preserve
enable
comment 'triiger 10 second'
do
select now() into outfile 'D:/abc.txt';
全站熱搜
留言列表
