MySql 使用数值型条件查询字符串类型的字段时遇到的问题
SQL如下:
select distinct(sb.dbid), sb.sbfl, jscs.jscsid, jscs.jscsvalue from sb left join jscs on sb.dbid = jscs.zsbtzid where sb.sbfl = 996802739625308160 and (jscs.jscsid = 1002229417948262401 and jscs.jscsvalue = 1015279442441842690) order by sb.dbid
查询结果如下: 出现了不符合查询条件的结果
具体原因还没有找到,但是如果将条件改为字符串类型
select distinct(sb.dbid), sb.sbfl, jscs.jscsid, jscs.jscsvalue from sb left join jscs on sb.dbid = jscs.zsbtzid where sb.sbfl = 996802739625308160 and (jscs.jscsid = 1002229417948262401 and jscs.jscsvalue = '1015279442441842690') order by sb.dbid