nttcar Posted April 4, 2008 Share 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 Link to comment Share on other sites More sharing options...
♥FWR Media Posted April 4, 2008 Share 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. Link to comment Share on other sites More sharing options...
nttcar Posted April 4, 2008 Author Share 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 Link to comment Share on other sites More sharing options...
nttcar Posted April 4, 2008 Author Share 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 Link to comment Share on other sites More sharing options...
♥FWR Media Posted April 4, 2008 Share 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. Link to comment Share on other sites More sharing options...
Guest Posted April 5, 2008 Share Posted April 5, 2008 Possibly get rid of the quote marks : ' ' around the table names. Quote Link to comment Share on other sites More sharing options...
cmakynen Posted April 5, 2008 Share 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 Link to comment Share on other sites More sharing options...
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.