Transfer records between tables

[eludlow]

I've got a fairly big table that has a list of members of an organisation.  However, some of these records are out of date, and I'd like to move them all to another table of "lost" members that will have the same structure as the main table.

 

It's easy for me to make something that inserts the old date into the new table and then deletes the record from the original table, but curious if mySQL has a function that will do this automatically?  I can imagine it's a fairly common thing to want done....

 

Thanks,

Ed Ludlow

[GOKU]

You can use

 

insert into new_table

select field1,field2,...fieldn from old_table where creteria