My table is as follows:
Value Distance
(float) (float)
----------------------------
2.0 42.3
1.0 56.9
3.2 20.0
1.3 18.5
I issued a query,
'update table set value=4.0 where distance=42.3'
But this doesn't work. This works fine with the values 20.0 and
18.5 and doesn't work with the values 42.3 and 56.9. The problem, I
discerned, was with the floating point comparison. Works fine with the
rounded figures like, 20.0 and 18.5, while doesn't work with others. Is
this the reason? In case yes, how do I solve the problem? I've tried
creating the distance column with an explicitly specified precision. But
doesn't work that way either.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
