mysql高级

 

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;