Copy MySQL table from one database to another

Posted on 6 April 2018 by kosmas

Problem

You would like to copy a table with its data from one database to another.

Solution

You can use the following:

INSERT INTO database2.table SELECT * from database1.table

1	INSERT INTO database2.table SELECT * from database1.table

taken from here

42