SQL -Structured Query Language - SQL Table - Copy Table Tutorial

To copy one SQL table into another SQL table of the same database. Then we can use a ' SELECT ' Statement.

Syntax-

The basic syntax of the SELECT statement to copy an existing SQL table into another SQL table is given below –

SELECT * INTO destination_table FROM source_table;

For example-

If we want to copy all data (a record) and column of user_detail table to employee_detail table

Then use the following syntax-

SELECT * INTO employee_detail FROM user_detail;

This query or statement will copy all data (a record) and column of user_detail table to employee_detail table.