You might have a table with some information and you want to copy the data of a few columns to another table. First thing you need to do is to create a table with columns same to the specific columns you require from original table.
You can copy data from one table to another no matter both the tables are in same database or different databases.
Let say you have two tables named table1 and table2 in database named db1.
