mysql字段类型不同导致的隐式转换问题
参考资料MySQL :: MySQL 8.0 Reference Manual :: 14.3 Type Conversion in Expression Evaluation
MySQL 避坑指南之隐式数据类型转换_mysql隐式转换整数转浮点数-CSDN博客
MySQL隐式转化整理 - Rollen Holt - 博客园 (cnblogs.com)
场景当两个字段类型不同,但要对他们进行运算,则会隐式的对其进行转换
文档原文:
If one or both arguments are NULL, the result of the comparison is NULL, except for the NULL-safe <=> equality comparison operator. For NULL <=> NULL, the result is true. No conversion is needed.
有一方类型为NULL,结果即为NULL,除非是太空船运算,NULL <=> NULL结果为true
If both a ...