SQL COPY TABLE
When working with databases, you may need to duplicate data from one table into another for analysis, backups, or temporary operations. This can be easily achieved using the SELECT INTO statement in SQL.
The SELECT INTO statement allows you to copy the data and structure of an existing table into a new table within the same database.
Complete Advance AI topics:- CLICK HERE
Complete Python Course with Advance topics:-Click here
Syntax of SELECT INTO Statement
SELECT * INTO New_Table_Name FROM Old_Table_Name;
SELECT INTO Statement Examples in SQL
To illustrate how to copy data from one table to another, consider the following examples:
Example 1: Copying All Data
Original Table: Vehicles
| Vehicle_Model | Vehicle_Color | Vehicle_Price |
|---|---|---|
| Honda Civic | Blue | 12,50,000 |
| Toyota Corolla | White | 14,00,000 |
| Ford Mustang | Red | 25,00,000 |
| Tesla Model 3 | Black | 35,00,000 |
SQL Query to Copy Data
SELECT * INTO Vehicle_Details FROM Vehicles;
Resulting Table: Vehicle_Details
| Vehicle_Model | Vehicle_Color | Vehicle_Price |
|---|---|---|
| Honda Civic | Blue | 12,50,000 |
| Toyota Corolla | White | 14,00,000 |
| Ford Mustang | Red | 25,00,000 |
| Tesla Model 3 | Black | 35,00,000 |
Example 2: Copying Specific Columns
Original Table: Gadgets
| Gadget_Name | Gadget_Brand | Price | Launch_Year |
|---|---|---|---|
| iPhone 14 | Apple | 80,000 | 2022 |
| Galaxy S22 | Samsung | 70,000 | 2022 |
| OnePlus 10 Pro | OnePlus | 60,000 | 2022 |
| Pixel 6 | 65,000 | 2022 |
SQL Query to Copy Selected Columns
SELECT Gadget_Name, Price INTO Gadget_Pricing FROM Gadgets;
Resulting Table: Gadget_Pricing
| Gadget_Name | Price |
|---|---|
| iPhone 14 | 80,000 |
| Galaxy S22 | 70,000 |
| OnePlus 10 Pro | 60,000 |
| Pixel 6 | 65,000 |
Example 3: Using WHERE Clause to Copy Data
Original Table: Books
| Book_ID | Book_Title | Genre | Price |
|---|---|---|---|
| 101 | The Alchemist | Fiction | 400 |
| 102 | Rich Dad Poor Dad | Self-help | 500 |
| 103 | The Lean Startup | Business | 600 |
| 104 | Atomic Habits | Self-help | 700 |
SQL Query to Copy Specific Rows
SELECT * INTO Self_Help_Books FROM Books WHERE Genre = 'Self-help';
Resulting Table: Self_Help_Books
| Book_ID | Book_Title | Genre | Price |
|---|---|---|---|
| 102 | Rich Dad Poor Dad | Self-help | 500 |
| 104 | Atomic Habits | Self-help | 700 |
Example 4: Adding a Condition to a New Table
Original Table: Laptops
| Laptop_Brand | Processor | RAM | Price |
|---|---|---|---|
| Dell | i7 | 16GB | 80,000 |
| HP | i5 | 8GB | 50,000 |
| Lenovo | Ryzen 5 | 16GB | 70,000 |
| Apple | M1 | 8GB | 1,00,000 |
SQL Query to Copy Data with a Price Filter
SELECT * INTO High_End_Laptops FROM Laptops WHERE Price > 75,000;
Resulting Table: High_End_Laptops
| Laptop_Brand | Processor | RAM | Price |
|---|---|---|---|
| Dell | i7 | 16GB | 80,000 |
| Apple | M1 | 8GB | 1,00,000 |
Syntax with WHERE Clause
You can also add conditions using the WHERE clause to filter the data being copied:
SELECT * INTO New_Table_Name FROM Old_Table_Name WHERE [condition];
Download New Real Time Projects :-Click here
Conclusion
The SELECT INTO statement in SQL provides a seamless way to duplicate data into new tables. Whether copying all records or only specific columns/rows, this method is efficient and easy to use. Use it thoughtfully to manage your data effectively.
For more SQL tips and tricks, visit UpdateGadh, your go-to destination for professional tech insights!
sql copy table to another table
how to create duplicate table in sql with data
sql copy table from one database to another
mysql copy table
sql select into existing table
how to copy table structure in sql without data
postgresql copy table
create table in sql
sql create table
sql joins
sql copy table w3schools
sql copy table example
sql copy table oracle
