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

Logan R
Logan R
22,989 Points

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!

Logan R
Logan R
22,989 Points

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

Steven Quinn
Steven Quinn
12,519 Points

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

Kevin Faust
Kevin Faust
15,353 Points

it doesnt return an error 0_o

Matthew Day
Matthew Day
6,740 Points

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).