addition - Why decimal add up incorrectly in mysql -


i want retrieve data based on condition in database :

select * `chatroom` 5.27680128733988 + 100.488135965769 = 105.764937253109 

this produced 0 result when there know value of addition 105.764937253109

to prove addition equals 105.764937253109 update 1 of row table correct value :

update `chatroom` set `latitude`= 5.27680128733988 + 100.488135965769 room_id = 2 

the updated column shows result of addition 105.764937253109 why when try select results in first database query, shows 0 data found?

thank you

because 5.27680128733988 + 100.488135965769 = 105.7649372531089; you're missing "8"


Comments

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

java - No use of nillable="0" in SOAP Webservice -

ubuntu - Laravel 5.2 quickstart guide gives Not Found Error -