How to copy an entire table from one database and paste to another data base?

Question

Database

Answer 1

yo may want to search for
DATABASE REPLICATION
https://www.codeproject.com/Articles/715550/SQL-Server-Replication-Step-by-Step

Answer 2

If both your databases lie on a single MySQL DBMS, you can use insert...select...
https://dev.mysql.com/doc/refman/5.7/en/insert-select.html

Answer 3

SQL SELECT...INTO statement copies data from one table and inserts into a new table(the table of same or different database). The syntax is as follows:-
SELECT <column_list>
INTO new_table_name[IN 'external_db_name']
FROM existing_table_name;

The *[IN external_db_name]* is not written in the query if the new table is to be created in the same database.