mysql – move rows from one table to another

A simple INSERT INTO SELECT statement:

INSERT INTO persons_table SELECT * FROM customer_table WHERE person_name="tom";

DELETE FROM customer_table WHERE person_name="tom";