mysqldump命令详解 Part 2- 建立触发器 事件

mysql>show databases;

mysql>use test
mysql>show tables;

select `name` from mysql.proc where db = 'test' and `type` = 'PROCEDURE' ;  //存储过程
select `name` from mysql.proc where db = 'test' and `type` = 'FUNCTION'  ; //函数

use test    
create table time (time varchar(100))

use test

CREATE TRIGGER trig1 AFTER INSERT
    ON  isam_table FOR EACH ROW
    INSERT INTO time VALUES(NOW());

SHOW TRIGGERS from test \G

mysql> use test
mysql> drop table if exists events_list;
mysql> create table events_list(event_name varchar(20) not null, event_started timestamp not null);

create event test.event_minute 
on schedule 
every  1 minute  
do insert into events_list values('event_now', now());

 set global event_scheduler =1;

 show processlist;

show events\G