{"id":501,"date":"2024-08-30T01:58:29","date_gmt":"2024-08-30T01:58:29","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=501"},"modified":"2025-06-02T12:11:02","modified_gmt":"2025-06-02T12:11:02","slug":"insert-into-select","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/insert-into-select\/","title":{"rendered":"INSERT INTO SELECT"},"content":{"rendered":"\n

SQL INSERT INTO SELECT Keyword<\/h2>\n\n\n\n

The INSERT INTO SELECT statement copies data from one table and inserts it into another. This is useful when transferring data between tables with similar structures.<\/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 Copy Names from Students to Doctors Example<\/h2>\n\n\n\n
This query copies names from the Students table into the Doctors table, filling only the first and last name columns. Other fields will be NULL.<\/p>\n\n\n\n
INSERT INTO Doctors (first_name, last_name)\nSELECT name, name\nFROM Students\nWHERE id < 5;<\/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 Copy Doctors into Patients Table Example<\/h2>\n\n\n\n
This query inserts rows from the Doctors table into the Patients table, providing fixed values for columns that require non-null data (like dob and gender):<\/p>\n\n\n\n
INSERT INTO Patients (first_name, last_name, dob, gender)\nSELECT first_name, last_name, '1990-01-01', 'F'\nFROM Doctors\nWHERE specialty IS NOT NULL;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL INSERT INTO SELECT Labs<\/h2>\n\n\n\n