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 michaelgosal
michaelgosal
1,896 Points

Issues in completing sql exercise - inserting data

I am having a difficulty in solving one of the challenge tasks - inserting data section.

The goal is to insert a new actor - "Michael J. Fox" into actors table.

I've tried:

Insert into actors values ("Michael J.Fox");

But it doesn't work. Perhaps I am missing something. Could someone shed some light on it?

Thanks in advance!

2 Answers

Matheus G Oliveira
Matheus G Oliveira
9,682 Points
Matheus G Oliveira
Matheus G Oliveira
9,682 Points

I think you are missing a space on the actors name. ("Michael J.Fox") and it is actually ("Michael J. Fox")

correct me if im wrong

michaelgosal
michaelgosal
1,896 Points

Omg! It works! Thanks Matheus! I didn't know such small typo like this affects the result!

Matheus G Oliveira
Matheus G Oliveira
9,682 Points
Matheus G Oliveira
Matheus G Oliveira
9,682 Points

Great man! Small things matter on programming, i had to learn that too! hahahha

good luck there

michaelgosal
michaelgosal
1,896 Points

Thanks! you, too!