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 ...