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;
收藏
0人收藏
- 2017-12-11 17:37:06表变量,代替临时表 by xuleaper
- 2017-12-11 09:36:54sql中order by(true or false) 类似 group by 的方式 by YuChao
- 2017-12-10 10:06:58一条比较SQL by xuleaper
- 2017-12-09 13:48:24一个效率很高的汉字转拼音首字母的函数 by YuChao
- 2017-12-09 10:25:26字符串变表带有表头 by fengsweat
- 2017-12-08 12:56:04SQL求小于1000的所有水仙花数 by 二糊
- 2017-12-08 09:17:05Oracle统计表的数据行和数据块信息 by Merrill
- 2017-12-06 09:59:48PLSQL生成流水号 by xuleaper
- 2017-12-05 15:48:21oracle建表备份脚本,如果update的数据不对,可以从WEB_RI_PLYEDR_CED_BAK找回 by YuChao
- 2017-12-05 15:18:40分组合并多列 by 董一碗
- 2018-03-30 21:56:50java自动识别用户上传的文本文件编码 by Hugh
相关聚客文章