作者:LAMP小白 点击:1909 发布日期:2012-11-11 12:48:00 返回列表
触发器(trigger)与数据表关联,当那个数据表被INSERT DELETE UPDATE语句修改时,触发器自动执行
mysql> delimiter $
mysql> CREATE TRIGGER user_list_insert BEFORE INSERT ON user_list
-> FOR EACH ROW BEGIN
-> IF NEW.name = 'liulibo' THEN
-> SET NEW.name = 'mio';
-> END IF;
-> END$
Query OK, 0 rows affected (0.06 sec)
mysql> INSERT INTO `user_list` SET `name`='liulibo';
-> $
Query OK, 1 row affected (0.01 sec)
mysql> delimiter ;
mysql> SELECT * FROM `user_list`;
+----+------+
| id | name |
+----+------+
| 1 | haha |
| 2 | mio |
+----+------+
2 rows in set (0.01 sec)
上一篇:存储函数和存储过程 下一篇:快递查询API