Is it possible to select entire row in a table and get sort of checksum? I am looking for a way to tell my code to update data only if at least one record has been changed. From perspective of data changes tracking it would help me to size down a number of changes noted in history table. - Thanks.
5条回答 默认 最新
- dsxon40042 2016-02-04 09:26关注
You can combine the
MD5()
andCONCAT()
functions to generate an MD5 checksum for the row:SELECT MD5(CONCAT(col1, col2, col3, ...)) as MD5_checksum FROM table;
If one of the columns is nullable, be sure you wrap it in
IFNULL(col, '')
, as a null will make the result of theCONCAT()
also null.Also be aware that this is not 100% save. If you remove the 1 character from a column and add it as the first character of the next column, the outcome of the
CONCAT()
and thus of the MD5 hash will be the same.本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
悬赏问题
- ¥15 多电路系统共用电源的串扰问题
- ¥15 slam rangenet++配置
- ¥15 有没有研究水声通信方面的帮我改俩matlab代码
- ¥15 对于相关问题的求解与代码
- ¥15 ubuntu子系统密码忘记
- ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
- ¥15 保护模式-系统加载-段寄存器
- ¥15 电脑桌面设定一个区域禁止鼠标操作
- ¥15 求NPF226060磁芯的详细资料
- ¥15 使用R语言marginaleffects包进行边际效应图绘制