触发器

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;