{"id":17928,"date":"2024-03-15T15:59:06","date_gmt":"2024-03-15T15:59:06","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/"},"modified":"2024-03-21T12:05:09","modified_gmt":"2024-03-21T12:05:09","slug":"what-are-the-differences-and-uses-of-select-into-and-insert-into-select","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/","title":{"rendered":"What are the differences and uses of SELECT INTO and INSERT INTO SELECT?"},"content":{"rendered":"

“SELECT INTO” and “INSERT INTO SELECT” are two different SQL statements used in relational databases to copy data from one table to another.<\/p>\n

    \n
  1. SELECT INTO statement is used to create a new table and copy data from the source table into the new table. The syntax is as follows:
    \nSELECT * INTO new_table FROM old_table WHERE condition;
    \nIn this statement, new_table is the name of the new table to be created, old_table is the name of the source table, and condition is an optional filtering condition. This statement will create a new table with the same structure as old_table and copy the data that meets the condition into the new table.<\/li>\n
  2. The INSERT INTO SELECT statement is used to insert data from a source table into an existing target table. The syntax is as follows:
    \nINSERT INTO target_table(column1, column2, …) SELECT column1, column2, … FROM source_table WHERE condition;
    \nIn this statement, target_table is the name of the target table, source_table is the name of the source table, and condition is an optional filtering condition. This statement will insert the source table data that meets the condition into the specified columns of the target table.<\/li>\n<\/ol>\n

    Summary:
    \nSELECT INTO is used to create a new table and copy data from the source table that meets the conditions into the new table;
    \nINSERT INTO SELECT is used to insert data from the source table that meets the conditions into an existing target table.<\/p>\n","protected":false},"excerpt":{"rendered":"

    “SELECT INTO” and “INSERT INTO SELECT” are two different SQL statements used in relational databases to copy data from one table to another. SELECT INTO statement is used to create a new table and copy data from the source table into the new table. The syntax is as follows: SELECT * INTO new_table FROM old_table […]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-17928","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nWhat are the differences and uses of SELECT INTO and INSERT INTO SELECT? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What are the differences and uses of SELECT INTO and INSERT INTO SELECT?\" \/>\n<meta property=\"og:description\" content=\"“SELECT INTO” and “INSERT INTO SELECT” are two different SQL statements used in relational databases to copy data from one table to another. SELECT INTO statement is used to create a new table and copy data from the source table into the new table. The syntax is as follows: SELECT * INTO new_table FROM old_table […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T15:59:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T12:05:09+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"William Carter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"What are the differences and uses of SELECT INTO and INSERT INTO SELECT?\",\"datePublished\":\"2024-03-15T15:59:06+00:00\",\"dateModified\":\"2024-03-21T12:05:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/\"},\"wordCount\":260,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/\",\"name\":\"What are the differences and uses of SELECT INTO and INSERT INTO SELECT? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T15:59:06+00:00\",\"dateModified\":\"2024-03-21T12:05:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What are the differences and uses of SELECT INTO and INSERT INTO SELECT?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What are the differences and uses of SELECT INTO and INSERT INTO SELECT? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/","og_locale":"en_US","og_type":"article","og_title":"What are the differences and uses of SELECT INTO and INSERT INTO SELECT?","og_description":"“SELECT INTO” and “INSERT INTO SELECT” are two different SQL statements used in relational databases to copy data from one table to another. SELECT INTO statement is used to create a new table and copy data from the source table into the new table. The syntax is as follows: SELECT * INTO new_table FROM old_table […]","og_url":"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T15:59:06+00:00","article_modified_time":"2024-03-21T12:05:09+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"What are the differences and uses of SELECT INTO and INSERT INTO SELECT?","datePublished":"2024-03-15T15:59:06+00:00","dateModified":"2024-03-21T12:05:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/"},"wordCount":260,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/","url":"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/","name":"What are the differences and uses of SELECT INTO and INSERT INTO SELECT? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T15:59:06+00:00","dateModified":"2024-03-21T12:05:09+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-differences-and-uses-of-select-into-and-insert-into-select\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What are the differences and uses of SELECT INTO and INSERT INTO SELECT?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/17928","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=17928"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/17928\/revisions"}],"predecessor-version":[{"id":51573,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/17928\/revisions\/51573"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=17928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=17928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=17928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}