Question

How can insert one tabel​

Answer 1

Answer:

The INSERT INTO SELECT statement copies data from one table and inserts it into another table.

1.INSERT INTO SELECT requires that data types in source and target tables match.

2.The existing records in the target table are unaffected.