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

Posted by Paul Vitalis
Paul Vitalis
Courses Plus Student 831 Points

Problem deleting user with the username poley_hands

I keep getting "no such column" why?

2 Answers

bothxp
bothxp
16,510 Points
bothxp
bothxp
16,510 Points

Hi Paul,

What were you using as your answer?

To delete specific rows from a table you would use:

DELETE FROM <table> WHERE <condition>;

From your error message I would suspect that you have got an issue in your condition. The answer should look something like:

DELETE FROM users WHERE username = "poley_hands";
Paul Vitalis
PLUS
Paul Vitalis
Courses Plus Student 831 Points
Paul Vitalis
Paul Vitalis
Courses Plus Student 831 Points

Thank you. I think what I was doing before was DELETE FROM username WHERE username = "poley_hands";