1、进入数据库
mysql> use cpc;
Database changed
2、输入 show events\G; 指令;
mysql> show events\G;
*************************** 1. row ***************************Db: cpc
Name: DATA_TO_state_count
Definer: root@localhost
Time zone: SYSTEM
Type: RECURRING
Execute at: NULL
Interval value: 1
Interval field: DAY
Starts: 2010-04-28 11:00:10
Ends: NULL
Status: ENABLED
Originator: 1
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 2. row ***************************
Db: cpc
Name: DATA_TO_terminal_alarm_list_bak
Definer: root@localhost
Time zone: SYSTEM
Type: RECURRING
Execute at: NULL
Interval value: 1
Interval field: DAY
Starts: 2010-04-28 00:00:10
Ends: NULL
Status: ENABLED
Originator: 1
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
*************************** 3. row ***************************