Re: error update
"Martin Gainty" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Multiply both operands by 100 Do the Multiplication Divide the result by .0001 Regards, -M ----- Original Message ----- From: "leong" <[email protected]> To: <[email protected]> Sent: Tuesday, August 12, 2003 7:29 PM Subject: error update > I have a field in type of float(20,2), > the value is 158059.45, i want to update to 158059.46, > but it can't update. > and there are some update have the same problem like, > 158059.01 will become 158059.02 > 158059.04 will become 158059.05 > 158059.07 will become 158059.06 > 158059.10 will become 158059.09 > 158059.13 will become 158059.12 > > can you help me with this problem? > > > -- > MySQL Bugs Mailing List > For list archives: http://lists.mysql.com/bugs > To unsubscribe: http://lists.mysql.com/[email protected] > > -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]