触发器

2015/11/17 36125

清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>> 

DELIMITER |

CREATE TRIGGER pseudohash_value_ins BEFORE INSERT ON app_tagType FOR EACH ROW BEGIN SET NEW.valueCrc32 = crc32(NEW.value);  

END;  

|  

CREATE TRIGGER pseudohash_value_upd BEFORE UPDATE ON app_tagType FOR EACH ROW BEGIN SET NEW.valueCrc32 = crc32(NEW.value);  

END;  

|  

DELIMITER;