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

Posted by Bularca Andrei
Bularca Andrei
2,408 Points

I think I'm blind

I can't seem to "see" why INSERT INTO actors VALUES ("Michael J.Fox") is not working ...

Ted Sumner
Ted Sumner
Courses Plus Student 17,967 Points

LOL. I have had blind moments myself. See Mikkel's answer.

Bularca Andrei
Bularca Andrei
2,408 Points

It has only 1 column , and in the first task movies table had 2 columns and it worked just fine :)

3 Answers

Steve Hunter
Steve Hunter
57,712 Points

You need a space after the J. 

INSERT INTO actors VALUES("Michael J. Fox")
Bularca Andrei
Bularca Andrei
2,408 Points

That solved the problem :) Thank you !

Steve Hunter
Steve Hunter
57,712 Points

No problem! :-)

Mikkel Rasmussen
Mikkel Rasmussen
31,772 Points
Mikkel Rasmussen
Mikkel Rasmussen
31,772 Points

You need to tel it which column in should be in.

INSERT INTO table_name (column1,column2,column3,...) VALUES (value1,value2,value3,...);

Bularca Andrei
Bularca Andrei
2,408 Points
Bularca Andrei
Bularca Andrei
2,408 Points

actors table has a single column