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

Development Tools Database Foundations Introduction to Data, Databases and SQL Inserting Data

I cannot keep going on since I can not answer the question correctly

I input the answer to insert a name of actors: INSERT INTO actors VALUES("Michael J.Fox");

It constantly displays that there's no Michael J.Fox, I can't figure out what's going on.

2 Answers

You need a space between the J. and Fox. The system thinks they are two different people.

INSERT INTO actors VALUES("Michael J.Fox");
INSERT INTO actors VALUES ("Michael J. Fox")

Thank you very much!

No problem :) If you have any more questions, feel free to ask them!

I have a similar problem. Can anybody tell me why this code is returning an error? INSERT INTO actors VALUES ("Michael J. Fox");

it doesnt return an error 0_o

This is old but in case someone in the future has the same problem.... It's possible that you are not using the correct type of double quote marks. There is a difference between straight quotes and curly quotes (see the answer posted here http://stackoverflow.com/questions/18735921/are-there-different-types-of-double-quotes-in-utf-8-php-str-replace).