{"id":3967,"date":"2025-06-07T08:28:31","date_gmt":"2025-06-07T08:28:31","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&p=3967"},"modified":"2025-06-07T10:00:26","modified_gmt":"2025-06-07T10:00:26","slug":"sql-select-into","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/sql\/sql-select-into\/","title":{"rendered":"SQL SELECT INTO"},"content":{"rendered":"\n

SELECT INTO<\/code> lets you create a new table<\/strong> and insert data<\/strong> from an existing query \u2014 all in one step.
It\u2019s handy for quick backups, snapshots, or creating temporary tables.<\/p>\n\n\n\n

\ud83d\udd39 Basic Syntax<\/h2>\n\n\n\n
SELECT column1, column2, ...\nINTO new_table\nFROM existing_table\nWHERE conditions;<\/code><\/code><\/pre>\n\n\n\n
\ud83d\udd39 How It Works<\/h2>\n\n\n\n
    \n
  • Creates new_table<\/code> with the same columns<\/strong> and data types<\/strong> as selected columns.<\/li>\n\n\n\n
  • Copies the data returned by the query<\/strong> into this new table.<\/li>\n\n\n\n
  • Only works if new_table<\/code> does not already exist<\/strong>.<\/li>\n<\/ul>\n\n\n\n
    \ud83d\udd39 Example<\/h2>\n\n\n\n
    Create a table high_salary_employees<\/code> with employees earning more than 70000:<\/p>\n\n\n\n
    SELECT employee_id, employee_name, salary\nINTO high_salary_employees\nFROM employees\nWHERE salary > 70000;<\/code><\/code><\/pre>\n\n\n\n
    \ud83d\udd39 Notes<\/h2>\n\n\n\n
      \n
    • Supported by SQL Server<\/strong> and some other DBMS (not standard in MySQL or Oracle).<\/li>\n\n\n\n
    • In MySQL, similar effect achieved with:<\/li>\n<\/ul>\n\n\n\n
      CREATE TABLE new_table AS\nSELECT column1, column2\nFROM existing_table\nWHERE conditions;<\/code><\/code><\/pre>\n\n\n\n
        \n
      • In Oracle, use CREATE TABLE AS SELECT<\/code> (CTAS).<\/li>\n<\/ul>\n\n\n\n
        \ud83e\udde0 Quick Recap<\/h2>\n\n\n\n
        Key Point<\/th>Explanation<\/th><\/tr><\/thead>
        Purpose<\/td>Create new table and fill it with query results<\/td><\/tr>
        Table must not exist<\/td>new_table<\/code> should not exist before execution<\/td><\/tr>
        DBMS differences<\/td>SELECT INTO<\/code> (SQL Server), CREATE TABLE AS<\/code> (MySQL, Oracle)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        \ud83d\udca1 Use SELECT INTO<\/code> to quickly clone or filter data into a new table without writing separate CREATE and INSERT commands.<\/p>\n","protected":false},"excerpt":{"rendered":"
        SELECT INTO lets you create a new table and insert data from an existing query \u2014 all in one step.It\u2019s handy for quick backups, snapshots, or creating temporary tables. \ud83d\udd39 Basic Syntax \ud83d\udd39 How It Works \ud83d\udd39 Example Create a table high_salary_employees with employees earning more than 70000: \ud83d\udd39 Notes \ud83e\udde0 Quick Recap Key Point […]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,979],"class_list":["post-3967","cposts","type-cposts","status-publish","hentry","category-notes","category-sql"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/3967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}