MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: how to delete a record in a table?
Posted by: Shantanu Oak
Date: June 30, 2005 09:00PM

DELETE FROM tablename
WHERE <criteria>

for e.g.

DELETE FROM antiques
WHERE item = 'Chair'

more such examples...
http://en.wikibooks.org/wiki/Appendix#appendix_16a_delete

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
how to delete a record in a table?
james nazareno
June 30, 2005 09:38AM
Re: how to delete a record in a table?
james nazareno
June 30, 2005 06:12PM
Re: how to delete a record in a table?
Shantanu Oak
June 30, 2005 09:00PM
Re: how to delete a record in a table?
james nazareno
June 30, 2005 09:39PM


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.