From: Dan Nelson
Date: February 5 2002 9:11pm
Subject: Re: deleting var="0.1"
List-Archive: http://lists.mysql.com/mysql/98646
Message-Id: <20020205211153.GL12749@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Feb 05), Matthias Hoffmann said:
> dear all.
> 
> I have a problem using mysql(occured at using phpMyAdmin):
> i send the query:
> DELETE FROM test WHERE user = "test" AND timestamp = "2002-02-05 21:42:53"
> AND var1="1000.1" LIMIT 1
> and 0 effect.
> but when var1 has a (INT) value there's no problem:
> DELETE FROM test WHERE user = "test" AND timestamp = "2002-02-05 21:42:53"
> AND var1="1000" LIMIT 1
> might there be a problem using such values?
> has this error already occurded? I just joined this list....

I assume var1 is a float in the first case?  Due to rounding issues,
the "=" operator will almost never work on fractions.  Use the primary
key to select which record to delete, or use a number range (var1
BETWEEN 1000.009 AND 1000.1001).

-- 
	Dan Nelson
	dnelson@stripped