MySQL视图,触发器,事物,存储过程,函数

create view 视图名 as select * from 表1 inner join 表2 on 表1.字段名 = 表2.字段名;  # 创建一个视图.

delimiter $$  # 只对当前窗口有效   
create trigger tri_before_insert_user before insert on user for each row
 begin
     select * from user
 end $$
  delimiter ; 讲结束符改会

CREATE TABLE cmd(
    id INT PRIMARY KEY auto_increment,
    USER CHAR (32),
    priv CHAR (10),
    cmd CHAR (64),
    sub_time datetime, #提交时间
    success enum ('yes', 'no') #0代表执行失败
);

CREATE TABLE errlog (
    id INT PRIMARY KEY auto_increment,
    err_cmd CHAR (64),
    err_time datetime
);

补充:NEW对象指代的就是当前记录
delimiter $$
create trigger tri_after_insert_cmd after insert on cmd for each row
begin
    if NEW.success = 'no' then
        insert into errlog(err_cmd,err_time) values(NEW.cmd,NEW.sub_time);
    end if;
end $$
delimiter ;