4. How to copy data from one table to another table?

How to copy data from one table to another table?

Answer

There are multiple ways to do this.
1)
INSERT INTO SELECT
This method is used when table is already created in the database earlier and data is to
be inserted into this table from another table. If columns listed in insert clause and
select clause are same, they are not required to list them.
2) SELECT INTO
This method is used when table is not created earlier and needs to be created when
data from one table is to be inserted into newly created table from another table. New
table is created with same data types as selected columns.

All sql Questions
Ask your interview questions on sql

Write Your comment or Questions if you want the answers on sql from sql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---