Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases

Viraj Kokane
Viraj Kokane
17,531 Points

Please help DELETE statement SQL!

What am I doing wrong here? Please help. Here's my code:

DELETE FROM products WHERE price <= 11;
Viraj Kokane
Viraj Kokane
17,531 Points

The question is: "We have an eCommerce database and it has a products table. It has the columns id, name, description and price. Delete all products priced at 11 or higher!"

2 Answers

Warren Pett
Warren Pett
1,612 Points

From the looks of the question isn't it:

DELETE FROM products WHERE price >= 11;
Viraj Kokane
Viraj Kokane
17,531 Points

Thanks Warren I just did a silly mistake. Thank you once again :)

Hi! What's the error you are getting?

Viraj Kokane
Viraj Kokane
17,531 Points

It's saying, "You didn't delete the correct rows."