nttcar Posted April 4, 2008 Posted April 4, 2008 I need to quick update the products_price when I run the sql from phpadmin, I got below error SQL query: udpate product SET products_price = products_price +10 MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'udpate product set products_price = products_price + 10' at line 1 Quote
♥FWR Media Posted April 4, 2008 Posted April 4, 2008 I need to quick update the products_price when I run the sql from phpadmin, I got below error SQL query: udpate product SET products_price = products_price +10 MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'udpate product set products_price = products_price + 10' at line 1 Well using a table that exists would be a good start. The table is products not product Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
nttcar Posted April 4, 2008 Author Posted April 4, 2008 Well using a table that exists would be a good start. I notice that and correct it and got same result The table is products not product udpate products SET `products_price` = `products_price` +10 MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'udpate products set `products_price` = `products_price` + 10' at line 1 Quote
nttcar Posted April 4, 2008 Author Posted April 4, 2008 udpate products SET `products_price` = `products_price` +10 MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'udpate products set `products_price` = `products_price` + 10' at line 1 Finall I got it, update need to be in UPPER case Quote
♥FWR Media Posted April 4, 2008 Posted April 4, 2008 Finall I got it, update need to be in UPPER case No it doesn't Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
Guest Posted April 5, 2008 Posted April 5, 2008 Possibly get rid of the quote marks : ' ' around the table names. Quote
cmakynen Posted April 5, 2008 Posted April 5, 2008 I need to quick update the products_price when I run the sql from phpadmin, I got below error SQL query: udpate product SET products_price = products_price +10 MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'udpate product set products_price = products_price + 10' at line 1 On the off change that you copy/pasted this verbatim from your system, you spelled the word "update" wrong... Quote
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.