MySQL Forums
Forum List  »  Archive Storage Engine

Re: Delete specific row from query
Posted by: KimSeong Loh
Date: August 31, 2008 04:42PM

If you mean delete all rows selected by "SELECT * FROM {$dbtable}" then it is as simple as "DELETE FROM {$dbtable}"

But, if you mean delete the rows selected by the user with the checked check boxes, then it is the application responsibility to determine the value of the rows and add a WHERE condition into the delete statement.

If you are using Archive storage engine, then delete is not supported.



Edited 1 time(s). Last edit at 08/31/2008 04:48PM by KimSeong Loh.

Options: ReplyQuote


Subject
Views
Written By
Posted
20437
August 22, 2008 06:08PM
Re: Delete specific row from query
9934
August 31, 2008 04:42PM


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.