Question: how to copy column data from one table to another table in mysql?
Answer: INSERT [IGNORE]
[INTO] table_name.
[(column_name, ...) ]
SELECT ...
FROM table_name WHERE ...