I need to be able to 'delete' records from table(s) but still maintain their
for an audit trail.
I'd rather not have a field for a deleted flag and have to condition all the
queries on the
table on the state of this flag.
Is it possible to move a record from one table to another easily?
Even better, can I do it opaquely (without knowledge of the columns)?
"move from LiveUsers to DeletedUsers where ID=?;"
where all the fields in the first table get moved to the corresponding field
of the 2nd. (If this is possible, what happens with autoincrement,
Thanks for the help; I hope it isn't a trivial question.
I'm new at this; I didn't find anything on moving records in the list