Hi Caroline, The syntax is:
delete from <table> where <condition...>; So, try this: delete from members where username='John Smith'; When deleting records from a table, always make sure you have a good condition clause, because if you don't have one, or if it's not correct, you could delete ALL of the records from that table. Regards, Bob :) -----Original Message----- From: Caroline Jen [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 5:49 PM To: [EMAIL PROTECTED] Subject: How To Delete A Particular Record From a Table? Hi, I am new in using database. I have created a table in a MySQL database. I want to delete a record from the "members" table. The record I want to delete is: user_name="John Smith". I tried: MySQL>delete John Smith from members; it does not work. MySQL>delete username='John Smith' from members; it does not work either. __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
