On 5 Feb 2002, at 15:11, Dan Nelson wrote:
> 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).
Matth
On Tuesday 05 February 2002 13:03, Matthias Hoffmann wrote:
> 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
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)
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 ti
