List:General Discussion« Previous MessageNext Message »
From:Matthias Hoffmann Date:February 5 2002 9:03pm
Subject:deleting var="0.1"
View as plain text  
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....

-Matthias Hoffmann

Thread
deleting var="0.1"Matthias Hoffmann5 Feb
  • Re: deleting var="0.1"Dan Nelson5 Feb
    • Re: deleting var="0.1"Keith C. Ivey6 Feb
  • Re: deleting var="0.1"Kyle Hayes5 Feb