[thelist] sql delete query error help
Tom Dell'Aringa
pixelmech at yahoo.com
Tue Jan 21 14:24:00 CST 2003
I'm trying to do a simple delete and I keep getting an error. Here it
is:
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...
??
Tom
=====
var me = tom.pixelmech.webDeveloper();
http://www.pixelmech.com/
http://www.maccaws.com/
[Making A Commercial Case for Adopting Web Standards]
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
More information about the thelist
mailing list