MySQL 触发器

------------------------------------------------------------------------------------------------------------------------------------------

MySQL 触发器：

------------------------------------------------------------------------------------------------------------------------------------------

DROP TRIGGER /*!50032 IF EXISTS */ `tcommodity_status_can_not_set_0`$$

CREATE

    /*!50017 DEFINER = 'root'@'%' */

    TRIGGER `tcommodity_status_can_not_set_0` BEFORE UPDATE ON `tcommodity` 

    FOR EACH ROW BEGIN

IF New.status = 0 THEN

CALL tcommodity_status_can_not_set_0();

END IF;

    END;

$$

DELIMITER ;

------------------------------------------------------------------------------------------------------------------------------------------