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!

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

Posted by Aquib Javed
Aquib Javed
8,289 Points

Unexpected error in inserting data into the "actors" table

Hi there, in the Database Foundations course, at the end of the first chapter, there's this code challenge for inserting data, where we have to insert 2 data into 2 different tables. The first one goes just fine. The second one, with the "actors" table is also exactly the same. It asks the following:

In the "actors" table INSERT a new actor with the name "Michael J. Fox".

Of which, I believe the answer is 

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

However this piece of code is showing error, consistently. Can someone point me out my mistake here?

Thanks

2 Answers

Dustin Matlock
Dustin Matlock
33,856 Points

Hello, Aquib. Looks like you just need a space in the name, e.g.,

INSERT INTO actors VALUES("Michael J. Fox");
Aquib Javed
Aquib Javed
8,289 Points
Aquib Javed
Aquib Javed
8,289 Points

Oh missed that. Thanks a lot Dustin :)