mysql触发器新增或修改_mysql触发器实例 插入数据前更改数据值

mysql触发器的例子，插入数据前更新数据的值，代码如下：

mysql> CREATE TABLE Employee(

-> id int,

-> first_name VARCHAR(15),

-> last_name VARCHAR(15),

-> start_date DATE,

-> end_date DATE,

-> salary FLOAT(8,2),

-> city VARCHAR(10),

-> description VARCHAR(15)

-> );

Query OK, 0 rows affected (0.03 sec)

mysql> DELIMITER //

mysql>

mysql> CREATE TRIGGER myTrigger BEFORE INSERT ON employee

-> FOR EACH ROW

-> BEGIN

->

-> IF NEW.salary IS NULL OR NEW.salary = 0 THEN

-> SET NEW.salary = 100;

-> ELSE

-> SET NEW.salary = NEW.salary + 100;

-> END IF;

->

-> END

->

-> //

Query OK, 0 rows affected (0.02 sec)

mysql> DELIMITER ;