MySQL Forums
Forum List  »  Newbie

Re: How Can I Delete Entire Row in Tables?
Posted by: Chad Bourque
Date: October 01, 2009 09:05AM

Carlos,

I depends on what makes your row unique. Based on your data, I would guess that username is unique. If that is true, then your query would be:
delete from it where username = 'jmadeline';
You should make sure each table has a primary key. Then, for updating and deleting data, you can use your primary key field in your where clauses.

HTH,
Chad

Options: ReplyQuote


Subject
Written By
Posted
Re: How Can I Delete Entire Row in Tables?
October 01, 2009 09:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.