{"id":262,"date":"2024-08-23T02:19:51","date_gmt":"2024-08-23T02:19:51","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=262"},"modified":"2025-05-13T13:58:08","modified_gmt":"2025-05-13T13:58:08","slug":"sql-insert-into-select","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/sql-insert-into-select\/","title":{"rendered":"SQL Insert Into Select"},"content":{"rendered":"\n

The SQL Insert Into Select statement allows you to copy data from one table into another. This command is useful when you want to transfer data between tables without manually inserting each row.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL Insert Into Select Syntax<\/h2>\n\n\n\n
INSERT INTO target_table (column1, column2, ...)\nSELECT column1, column2, ...\nFROM source_table\nWHERE condition;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL Insert Into Select Basic Example<\/h2>\n\n\n\n
This query creates a new table called NewPatients and inserts all patient data from the Patients table into it.<\/p>\n\n\n\n
CREATE TABLE NewPatients (\n    patient_id INTEGER,\n    first_name TEXT,\n    last_name TEXT\n);\n\nINSERT INTO NewPatients (patient_id, first_name, last_name)\nSELECT patient_id, first_name, last_name\nFROM Patients;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL Insert Into Select with Condition Example<\/h2>\n\n\n\n
This query copies only the patients whose first name starts with ‘A’ from the Patients table to the NewPatients table.<\/p>\n\n\n\n
INSERT INTO NewPatients (patient_id, first_name, last_name)\nSELECT patient_id, first_name, last_name\nFROM Patients\nWHERE first_name LIKE 'A%';<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL Insert Into Select Visual Diagram<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL Insert Into Select Labs<\/h2>\n\n\n\n