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 trialEric Montenegro
2,523 PointsWe'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
Courses Plus Student 94,610 PointsHi 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
15,258 PointsI 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
7,168 PointsI realized the syntax is: DELETE <column name> FROM <tablename>;
Yes, this one was tricky.
Manav Dhall
776 PointsDelete 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.