[thelist] sql delete query error help
m guckeyson
markguy27 at ameritech.net
Tue Jan 21 14:28:15 CST 2003
I'm not 100% sure here, but it's usually pretty hard to delete just a field
from a table... shouldn't this read:
DELETE FROM prodtemp WHERE pid = 145
?
SQL-query :
>DELETE prodtemp.prodName FROM prodtemp WHERE pid = 145
>
>MySQL said:
>You have an error in your SQL syntax near 'prodtemp.prodName FROM
>prodtemp WHERE pid = 145' at line 1
>
>This makes no sense! prodtemp is most definitely the name of the
>table. pid is indeed a field as is prodName. 145 does exist in the
>table...
More information about the thelist
mailing list