Thanks a lot, it worked with the double datatype!
On Fri, 14 Jun 2002, Michael Ivanyo wrote:
> I've had similar problems with this in my career and
> have come to the conclusion that one should always use
> double floats. The problem is typically due to round
> off errors of the float
"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:
&g
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 ta
