mysql 触发器 实例_mysql的触发器-含案例-含效果 | 时刻需

今天做下触发器的笔记

原来都是用命令的，现在好多都用工具了。

情景一： after

插入本表一 order 后再修改表二 push

表一：

CREATE TABLE `33hao_order` (

`id` int(8) unsigned NOT NULL AUTO_INCREMENT,

`name` varchar(30) DEFAULT NULL,

`state` tinyint(1) unsigned NOT NULL DEFAULT '1',

`goods_id` int(8) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

CREATE TRIGGER `order_add_after` AFTER INSERT ON `33hao_order` FOR EACH ROW begin

declare flag_num int(10);

set flag_num = (select count(*) as flag_num from 33hao_order where id=new.id) ;

if flag_num =1 then

insert into 33hao_push (push_desc,item_id) values (new.id,6);

end if;

end;

表二：

CREATE TABLE `33hao_push` (

<