Create Table |
1.创建数据表
|
DELIMITER $$
2.创建触发器示例
(1)CREATE
/*[DEFINER = { user | CURRENT_USER }]*/
TRIGGER `mytest`.`tri_amount2` BEFORE UPDATE
ON `mytest`.`amount`
FOR EACH ROW BEGIN
IF (NEW.amount < 0) THEN
SET NEW.amount = 0;tri_amount1
ELSEIF (NEW.amount > 100) THEN
SET NEW.amount = 100;
END IF;
END$$
DELIMITER ;
2.创建触发器示例
(1)CREATE
/*[DEFINER = { user | CURRENT_USER }]*/
TRIGGER `mytest`.`tri_amount2` BEFORE UPDATE
ON `mytest`.`amount`
FOR EACH ROW BEGIN
IF (NEW.amount < 0) THEN
SET NEW.amount = 0;tri_amount1
ELSEIF (NEW.amount > 100) THEN
SET NEW.amount = 100;
END IF;
END$$
DELIMITER ;
再插入时触发这个程序
(2)BEGIN
IF (NEW.amount < 0) THEN
SET NEW.amount = 0;
ELSEIF (NEW.amount > 100) THEN
SET NEW.amount = 100;
END IF;
END
IF (NEW.amount < 0) THEN
SET NEW.amount = 0;
ELSEIF (NEW.amount > 100) THEN
SET NEW.amount = 100;
END IF;
END