- 博客(2)
- 收藏
- 关注
原创 mysql字符串类型的数字大小比较
SELECT a.* FROM test a WHERE left(a.probability,length(a.probability)-1) > 90 SELECT a.* FROM test a WHERE left(a.probability,length(a.probability)-1) > '90'a.probability = '100%'结果不...
2019-01-09 15:09:03 9916
原创 mysql查询中带空格
SELECT * FROM `test` WHERE `id` = '123' 无空格正常查询结果SELECT * FROM `test` WHERE `id` = '123 ' 字符串后面加空格正常查询结果SELECT * FROM `test` WHERE `id` = ' 123' 字符串前面加空格结果为空...
2019-01-03 12:16:49 2038
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人