code to move ietms from one table to another myswl

INSERT [IGNORE]  [INTO] table_name  [(column_name, ...) ]SELECT ...FROM table_name WHERE ...