有趣的SQL DIGEST
- SQL DIGEST是什么
- SQL DIGEST有什么作用
- 代码中与SQL DIGEST相关的处理函数
- 常见问题
SQL DIGEST是什么
DIGEST TEXT
DIGEST TEXT本质是一种SQL语句规范化后将常量替换成'?'的运算结果，STATEMENT_DIGEST_TEXT函数用于计算语句的DIGEST TEXT(摘要文本)
mysql> SELECT STATEMENT_DIGEST_TEXT('SELECT * FroM T1 WHERE c1 > 10 and c2="abc" AND 1+SIN(3) > 0;') AS label;+------------------------------------------------------------------------+| label |+------------------------------------------------------------------------+| SELECT * FROM `T1` WHERE `c1` > ? AND `c2` = ? AND ? + `SIN` (?) > ? ; |+------------------------------------------------------------------------+1 row in set (0.00 sec)
