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 insert into history_table (colA, colB, colC,...) select (col1, col2, col3, ...) from active_table; Hope that helps, Swany --- darren <[EMAIL PROTECTED]> 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. > i.e. a "select * from > active where key=key_value limit 1" and then a > "insert into history..." and > then a "delete * from active where > pri_key='pri_key_value'..." > > I am sure there's a better way right?? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
