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

Databases Modifying Data with SQL Deleting Data From a Database Review and Practice

Posted by Eric Montenegro
Eric Montenegro
2,523 Points

We've removed the reviews section from our website. Please remove all reviews. DELETE FROM reviews WHERE review = ??

I tried several conditions and I still have trouble figuring out how to delete the review column only. Rewatching the video to this question did not help. I was able to do the other 3 SQL Playground questions but this one stumped me.

4 Answers

Jason Anello
Jason Anello
Courses Plus Student 94,610 Points

Hi Eric,

It's asking you to remove all the rows from the table. Each row represents a review. So in order to remove a review, you have to delete the entire row. Not just the text of the review.

So for this query, you don't need the WHERE condition.

Luke Vaughan
Luke Vaughan
15,258 Points
Luke Vaughan
Luke Vaughan
15,258 Points

I think you are thinking too deep into the question. He is only asking to remove Reviews from the database not the reviews column 

delete from reviews;
Marie Urbina
Marie Urbina
7,168 Points
Marie Urbina
Marie Urbina
7,168 Points

I realized the syntax is: DELETE <column name> FROM <tablename>;

Yes, this one was tricky.

Manav Dhall
Manav Dhall
776 Points
Manav Dhall
Manav Dhall
776 Points

Delete from reviews;

You did not require the where clause here as you want to delete all the records. This can be rolled back as delete is not auto commited.