Deletion and Mark for deletion.

[GBONGIOVANO]

I am doing a presentation on Perl DBI and MySQL.
I am using perl DBI to interact with my MySQL database.
I know how to delete from the database but how do I MARK for deletion.
Thank you
G

 

[sleipnir214]

There is no intrisic mechanism in MySQL -- changes are committed as quickly as the server can get to them. You'll have to implement it yourself.

Add a column to the table in question which sets the status as "In use" or "marked for deletion". Make sure your queries are aware of the column. Purging is just deleting those rows the status of which is "marked for deletion" Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!