+ 4

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


31st Mar 2017, 4:46 AM
Dave - avatar
3 Answers
31st Mar 2017, 5:52 AM
seamiki - avatar
+ 4
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
31st Mar 2017, 5:23 AM
+ 1
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.
10th Apr 2017, 12:05 PM
Urvashi Jain
Urvashi Jain - avatar