I need advice on archiving data from our production
database.
Each night I would like to save and remove
a day's data from two weeks ago, from all the tables. I know how to delete
the data--though our schema does not specify cascaded deletes. However, I can't
figure out how to save the d
Thank you so much, I guess my sql skills need sharpening. I have been trying
all night to find out how to do a join with delete. I thought I needed to
mention t2 in the from clause, but that didn't work. This worked great.
Sally
- Original Message -
From: "Martijn van Oosterhout" <[EMAIL
