BEFORE INSERT,BEFORE DELETE,BEFORE UPDATE

AFTER INSERT,AFTER DELETE,AFTER UPDATE

创建触发器

mysql> create table log(id int primary key auto_increment not null,

-> time datetime);

mysql> delimiter ||

mysql> create trigger demo after update

-> on student for each row

-> begin

-> insert into log values(now());

-> end

-> ||

创建存储过程

mysql> delimiter ||

mysql> create procedure delete_stu(in stuid int)

-> begin

-> delete from student where id = stuid

-> ;

-> end

-> ||

Query OK, 0 rows affected (0.29 sec)

mysql> delimiter;

mysql> create view v_stu(vid, vname) as select id, name from student;

Query OK, 0 rows affected (0.00 sec)

mysql> select * from v_stu;

// 查看表中索引

mysql> show index from student;

// 创建索引

mysql> create index stu_index on student(index);

// 删除索引

mysql> drop index stu_index on student;