Home  >  Article  >  Database  >  MySql最简单的触发器例子_MySQL

MySql最简单的触发器例子_MySQL

WBOY
WBOYOriginal
2016-06-01 13:29:37912browse

bitsCN.com MySql最简单的触发器例子

 

如下:

 

[sql] DROP TRIGGER IF EXISTS t_afterupdate_on_tab1;  CREATE TRIGGER t_afterupdate_on_tab1  AFTER UPDATE ON tab1  FOR EACH ROW  BEGIN      delete from tab2 where old.status=0 and pid=old.id;  END;  

 


bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn