September 7th, 2012, 11:37 AM
Getting an error #1064 with an INSERT statement??????
The statement is
From what I can see the statement looks correct. I am getting an error of
INSERT INTO gtr_shop1_products (categoryID, productCode, productName, listPrice) VALUES (1, ‘tele’, ‘Fender Telecaster’, 599.00);
#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 'Telecasterâ€™, 599.00)' at line 1
Would someone help me understand this? Thank you.
September 7th, 2012, 12:00 PM
try using single quote marks like ' instead of the quotes you are using. they may be getting translated incorrectly.
Comments on this post
September 7th, 2012, 12:27 PM
That worked I appreciate it. Thank you.
September 7th, 2012, 01:31 PM
yet another mysql developer pwned my microsoft word