Move data from one MySQL table to another code example
Example: code to move ietms from one table to another myswl
INSERT [IGNORE] [INTO] table_name [(column_name, ...) ]SELECT ...FROM table_name WHERE ...
INSERT [IGNORE] [INTO] table_name [(column_name, ...) ]SELECT ...FROM table_name WHERE ...