Hi all,
Thanks for the help.
So I can Insert into archive_table select * from active_table where
condition='true', followed by a delete from active_table...
If my archive_tabler is nearly exactly the same but has two more fields
(housekeep_id, and now()), how do I modify the above statement to
to:
|
| Subject: RE: moving records between tables
darren wrote:
Hi all,
I have 2 tables...one for keeping active items while the other is for older
records.
A housekeep program will come in every night to move some records (matching
several criteria from the active table to the history one.
I am currently doing SELECT, INSERT and then DELETE.
LOCK TABLE active_table WRITE, history_table WRITE;
#assuming the columns in the tables are exactly
#the same
insert into history_table
select * from active_table;
delete from active_table;
UNLOCK TABLES;
if the columns aren't the same between the tables then
you need to do something like