inexplicit专题

MySQL隐式转换(inexplicit conversion)

禁止使用属性隐式转换 解读:SELECT uid FROM t_user WHERE phone=13812345678 会导致全表扫描,而不能命中phone索引。而SELECT uid FROM t_user WHERE phone=‘13812345678’可以索引 原因如下:https://www.jianshu.com/p/6f34e9708a80