Generating an INSERT statement from a SELECT before deleting
Posted on 2010-11-11
I want to give customers the ability to delete data on a web site (LAMP). Before each deletion I would like to generate and store an INSERT statement that could be used to restore the data if the deletion was in error.
I would guess that this is a common need and I was hoping that there are known functions, instruction sets, or a php class that already exists to do this. I haven't found anything in my searching so far. Does anyone know of such a script?