How to import into a database in a certain table data from the same database that has the same table and fields but different data?

Question

MySQL

How to import into a database in a certain table data from the same database that has the same table and fields but different data?
Preferably through phpmyadmin but other ways are possible.

Answer 1

insert into ... select ... where
compose an insert query with a select subquery