Question: how to copy data from one table to another table in same database in mysql?
Answer: The complete command of copying data from an existing table to the new one is as follows: CREATE TABLE new_table SELECT col1, col2, col3 FROM existing_table WHERE conditions; Note that the statement above just copies the table and its data.