How Can I Insert Data from One Table to Another Using a SELECT Statement in SQL?

Using SELECT Statements for Data Insertion in SQL

Moving data between tables using a SELECT statement is a fundamental SQL task. While the precise syntax might differ slightly between database systems, a standardized approach ensures broader compatibility.

Standard SQL Syntax for Data Insertion

For maximum compatibility, employ this standard SQL syntax:

INSERT INTO target_table (target_column1, target_column2, ...)
SELECT source_column1, source_column2, ...
FROM source_table
WHERE condition; -- Optional WHERE clause to filter data

This method is designed to work seamlessly across various SQL databases.

Confirmed Database System Compatibility

This standard syntax has been verified to function correctly with the following database management systems:

• Oracle
• Microsoft SQL Server
• MySQL
• PostgreSQL
• SQLite v3
• Teradata
• DB2
• Sybase
• Vertica
• HSQLDB
• H2
• AWS RedShift
• SAP HANA
• Google Spanner

This approach offers a robust and portable solution for transferring data efficiently between SQL tables. Remember to adjust column names and potentially add a WHERE clause to refine the data selection as needed.

The above is the detailed content of How Can I Insert Data from One Table to Another Using a SELECT Statement in SQL?. For more information, please follow other related articles on the PHP Chinese website!