mysql触发器的创建和使用

create table if not exists user(
 uid int primary key auto_increment,
 username varchar(50) not null,
 password varchar(50) not null
)default charset=utf8;

create table if not exists user_logs(
 id int primary key auto_increment,
 time timestamp,
 log_text varchar(100)
 )default charset=utf8;

create trigger trigger_test1 after insert on user for each row
insert into user_logs values(NULL,now(),'new');

insert into user values(2,'zbb','123456');
update user SET username='zcc' WHERE uid=2;