yrstruly Posted April 1, 2009 Share Posted April 1, 2009 Hallo Can Somebody PLEASE HELP ME. I have copied this SQL code out of a particular book. All the sql codes i have copied to far to create the ecommerce database is working fine till now.Here the code follows.INSERT INTO categories (category)VALUES(‘Widgets That Wiggle’),(‘Widgets That Bounce’),(‘Widgets That Sit There’),(‘Non-widget Widgets’),(‘Fuzzy Widgets’),(‘Razor-sharp Widgets’);I am getting this error message: #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 'That Wiggle’), (‘Widgets That Bounce’), (‘Widgets That Sit There’), ' at line 3b]Can somebody please help me? Link to comment Share on other sites More sharing options...
jeffman Posted April 1, 2009 Share Posted April 1, 2009 Never use curly quotes. Use plain quotes for values. Some systems require backticks for column names. Link to comment Share on other sites More sharing options...
yrstruly Posted April 1, 2009 Author Share Posted April 1, 2009 Never use curly quotes. Use plain quotes for values. Some systems require backticks for column names.THANK YOU! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.