mysql trigger
来源:互联网 发布:分子结构式软件 编辑:程序博客网 时间:2024/05/22 13:23
This is about a very simply trigger but which is very useful :
syntax:
CREATE TRIGGER <trigger name> <--
{ BEFORE | AFTER }
{ INSERT | UPDATE | DELETE }
ON <table name>
FOR EACH ROW
<the sql general statement which will be triggered>
e.g:
create trigger table_insert after insert on table1 for each row insert into table2(`field`) value('value');
when you create trigger 'table_insert' like the code above , then insert a row in to table1, it also will insert a row into table2 field2=>value;
want to see you created trigger code: show triggers;
for delete trigger: drop trigger <trigger name>
note: you must have enough proviledge to create trigger , if you haven't it will failed
- mysql trigger
- mysql trigger
- mysql trigger
- mysql trigger
- mysql trigger
- Mysql Trigger
- MySQL TRIGGER
- MySQL TRIGGER
- mysql create trigger
- mysql insert trigger
- 【转】mysql-trigger-触发器
- TRIGGER:Mysql触发器
- mysql之触发器trigger
- MYSQL触发器(Trigger)
- mysql 之触发器 trigger
- mysql之触发器trigger
- MySQL触发器 trigger学习
- mysql之触发器trigger
- python getopt
- GestureOverlayView
- 理解JAVA多态,总结整理
- Answer to Chapter 7 of O'Reilly Learning Sql on SQL Server 2005
- 算法思想笔记——分治法
- mysql trigger
- 了解字符集
- 黑马程序员训练营:动态代理
- 继续理解java多态性
- Arduino第二次实验—倒计时牌
- 区分RISC,CISC,Harvard architecture,Von_Neumann_architecture
- B/S 与 C/S相结合
- [转]URL中的井号
- Case具有两种格式。简单Case函数和Case搜索函数。