error 1064 insert into
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about mysql error 1064 insert 42000 hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask
Error 1064 MysqldumpQuestion x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.
Sql Error 1064Join them; it only takes a minute: Sign up SQL INSERT INTO Error #1064 on phpMyAdmin up vote 0 down vote favorite My code keeps giving me the following error: #1064 - You have an error in your SQL
Search Username Password Remember Me? Register Lost Password? facebook google twitter rss Free Web Developer Tools Advanced Search Forum Databases MySQL Help Getting an error #1064 http://forums.devshed.com/mysql-help/930294-getting-error-1064-insert-statement-post2818802.html with an INSERT statement?????? Thread: Getting an error #1064 with an INSERT statement?????? Share This Thread Tweet This + 1 this Post To Linkedin Subscribe to this Thread Subscribe to This Thread September 7th, 2012,10:37 AM #1 No Profile Picture dlmagers View Profile View Forum Posts Visit Homepage Registered User Devshed Newbie (0 - 499 error 1064 posts) Join Date Jun 2011 Location Rocky Mount, NC Posts 16 Rep Power 0 Getting an error #1064 with an INSERT statement?????? The statement is Code: INSERT INTO gtr_shop1_products (categoryID, productCode, productName, listPrice) VALUES (1, ‘tele’, ‘Fender Telecaster’, 599.00); From what I can see the statement looks correct. I am getting an error of #1064 - You have an error 1064 mysql 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. Faq Reply With Quote September 7th, 2012,11:00 AM #2 Guelphdad View Profile View Forum Posts Hockey face Devshed Supreme Being (6500+ posts) Join Date Nov 2001 Location St. Catharines, Canada Posts 8,142 Rep Power 1318 try using single quote marks like ' instead of the quotes you are using. they may be getting translated incorrectly. Comments on this post paulh1983 agrees : it definitely is that. Faq Reply With Quote September 7th, 2012,11:27 AM #3 No Profile Picture dlmagers View Profile View Forum Posts Visit Homepage Registered User Devshed Newbie (0 - 499 posts) Join Date Jun 2011 Location Rocky Mount, NC Posts 16 Rep Power 0 Thanks That worked I appreciate it. Thank you. Faq Reply With Quote September 7th, 2