MYSQL - copy data to another database

Question

I want to copy Data in tempTablefrom Database1to Database2, I tried, but what about my code:

INSERT INTO Database1.tempTable 
FROM Database2.tempTable

Answer 1

The easiest way -

INSERT INTO Database.Table1(field 1, field 2,...)
SELECT * FROM Database2.Table2;


INSERT INTO Database1.tempTable (field 1, field 2,...)
SELECT * FROM Database2.tempTable

You can also use

  INSERT INTO Database2.Table SELECT * from Database1.Table

Answer 2

The easiest way to do this is to

INSERT INTO database2.table2 SELECT * from database1.table1