Question: how to copy table with data from one database to another 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.