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:

<code class="language-sql">INSERT INTO target_table (target_column1, target_column2, ...)
SELECT source_column1, source_column2, ...
FROM source_table
WHERE condition; -- Optional WHERE clause to filter data</code>

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!