Using MySQL. Is it possible to move records from table to another.

Any hint would greatly be appreciated.