"select version();" "show create table ...;"
----- Original Message ----- From: "Vandana" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 7:01 PM Subject: A simple query, please help > > 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 > > --------------------------------------------------------------------- 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
