数据库中明明有数据:
select * from talbe where version = 1.1
总是查不到数据但是
select * from talbe where version = 1
就能查到
解决用:精确查询格式下
select * from table where format(version,4) =format(1.1,4)
就能查到了
数据库中明明有数据:
select * from talbe where version = 1.1
总是查不到数据但是
select * from talbe where version = 1
就能查到
解决用:精确查询格式下
select * from table where format(version,4) =format(1.1,4)
就能查到了