Problem with <= operator, MySQL 4.1.12
Well, I'm stumped. I have a float 13,2 column "balance' in my MyIsam table. One of the values in that column is 122.41. The query "select balance from master where balance >= 122.41" returns all the rows with values greater than or equal to 122.41, including 122.41. However, the query "select balance from master where balance <= 122.41 does NOT include 122.41 in the resultset. Nor can I establish equality on 122.41. "select balance from master where balance = 122.41" returns an empty result set. What am I missing here?
Subject
Written By
Posted
Problem with <= operator, MySQL 4.1.12
July 30, 2005 09:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.