请教高手,这是为什么
1 select * from table
where id = '1.00011880000000000e+007'
2 select * from table
where id = 1.00011880000000000e+007
3 select * from table
where id = 10001188
4 select * from table
where id = '10001188'
id 是 int
1 不能检索出数据
2,3,4 则可检索出数据
注 select 10001188 = '1.00011880000000000e+007'
-> 1
只想知道为什么?