Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
MUZ141105 Shingirai Shoko
4,643 PointsIn the "actors" table INSERT a new actor with the name "Michael J. Fox".
If some 1 could tell whats wrong with my code, i would greatly appreciate am getting this........ SQL Error: 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 'INSERT INTO actors VALUES ("Michael J.Fox".)' at line 1
2 Answers
Steve Hunter
57,712 PointsYou certainly need a space after the J. before Fox.
I'll have a go and see what else might be a problem.
Steve.
MUZ141105 Shingirai Shoko
4,643 Pointswaaalll thank yu so much steve had been stuck on that alll day
Steve Hunter
57,712 PointsNo problem! :-)
Steve Hunter
57,712 PointsSteve Hunter
57,712 PointsThis works:
INSERT INTO actors VALUES("Michael J. Fox")So I guess it is that space and the full stop inside the bracket. (
("Michael J.Fox".))Steve.