{"id":94137,"date":"2020-09-11T11:00:00","date_gmt":"2020-09-11T08:00:00","guid":{"rendered":"https:\/\/examples.javacodegeeks.com\/?p=94137"},"modified":"2021-11-07T23:43:54","modified_gmt":"2021-11-07T21:43:54","slug":"sql-insert-into-select-statement-example","status":"publish","type":"post","link":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/","title":{"rendered":"SQL INSERT INTO SELECT Statement Example"},"content":{"rendered":"<p>In this article, we will explain SQL INSERT INTO SELECT Statement through examples.<\/p>\n<p>You might have used a &#8216;select&#8217; statement, and the &#8216;insert into&#8217; statement in SQL separately. The select statement is used to fetch data from the database whereas the &#8216;insert into&#8217; statement inserts data into the table. In this particular example, we will learn the usage of the <code>insert into select<\/code> statement in SQL. <\/p>\n<h2 class=\"wp-block-heading\" id=\"h-1-about-sql-insert-into-select-statement\">1. About SQL INSERT INTO SELECT Statement<\/h2>\n<p class=\"has-normal-font-size\">The SQL Insert Into Select statement is used to copy the data from one table ( let us call it the source table ) into another table ( let us call it the destination table).<\/p>\n<p><strong>Note:<\/strong><\/p>\n<ul class=\"wp-block-list\">\n<li>This statement only works in the case if the data types of both the source and destination tables match.<\/li>\n<li>The already existing data in the destination table will not have any changes once the insert into a select statement is applied to the destination table. <\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\" id=\"h-2-insert-into-select-syntax\">2. INSERT INTO SELECT Syntax<\/h2>\n<p>If you want to select all the columns from the source table, and copy it to the destination table, then the following syntax will work.<\/p>\n<div class=\"wp-block-syntaxhighlighter-code \">\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nINSERT INTO destinationTableName (columnNames)\nSELECT *\nFROM sourceTableName\nWHERE condition\n<\/pre>\n<\/div>\n<p>If you want to select particular columns from the destination table, then the following syntax will work. Note that columnNames will be a list of columns separated by a comma.<\/p>\n<div class=\"wp-block-syntaxhighlighter-code \">\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nINSERT INTO destinationTableName (columnNames)\nSELECT columnNames \nFROM sourceTableName\nWHERE condition\n<\/pre>\n<\/div>\n<h2 class=\"wp-block-heading\" id=\"h-3-insert-into-select-example\">3. INSERT INTO SELECT Example<\/h2>\n<p>We will be using the MySQL Command line to show how Insert Into Select statement is used. You can also do the same either by using the MySQL compiler available online or the MySQL Workbench. By using Insert Into Select statement, we will be copying data from source to destination table.<div style=\"display:inline-block; margin: 15px 0;\"> <div id=\"adngin-JavaCodeGeeks_incontent_video-0\" style=\"display:inline-block;\"><\/div> <\/div><\/p>\n<h3 class=\"wp-block-heading\" id=\"h-3-1-creating-two-demo-tables-source-and-destination\">3.1 Creating two demo tables &#8211; source and destination<\/h3>\n<p>As an example, two tables have been created namely <code>STUDENT<\/code>, and <code>VOLUNTEER.<\/code> The STUDENT table consists of 3 columns that include the studentId, studentName, and country. Similarly, the VOLUNTEER table also comprises of 3 columns that include the volunteerId, volunteerName and country. <\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1108\" height=\"635\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlCreateTables.jpg\" alt=\"SQL INSERT INTO SELECT - the tables student and volunteer\" class=\"wp-image-94210\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlCreateTables.jpg 1108w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlCreateTables-300x172.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlCreateTables-1024x587.jpg 1024w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlCreateTables-768x440.jpg 768w\" sizes=\"(max-width: 1108px) 100vw, 1108px\" \/><figcaption>Fig 1: Creating the tables &#8211; student and volunteer<\/figcaption><\/figure>\n<h3 class=\"wp-block-heading\" id=\"h-3-2-inserting-data-into-the-two-tables\">3.2 Inserting Data into the two tables <\/h3>\n<p>Some sample data has been inserted into the two tables STUDENT and VOLUNTEER using the <code>insert <\/code>command.<\/p>\n<p><span style=\"text-decoration: underline\">Note:<\/span>  If any mistake is made in the data types for the respective values, then it will result in an error and insertion will not be successful. So, make sure that the string is enclosed in single quotes. <\/p>\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1019\" height=\"479\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlInsertData.jpg\" alt=\"SQL INSERT INTO SELECT - Data inserted\" class=\"wp-image-94215\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlInsertData.jpg 1019w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlInsertData-300x141.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlInsertData-768x361.jpg 768w\" sizes=\"(max-width: 1019px) 100vw, 1019px\" \/><figcaption>Fig 2. Data inserted in student and volunteer<\/figcaption><\/figure>\n<p>Let us see how the data looks after inserting the rows into the tables. We have used the <code>select <\/code>command to fetch the data in both tables. You can see that there are 3 rows inserted in the student table successfully, and 3 rows in the volunteer table successfully as well. <\/p>\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"512\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlSelectData-1024x512.jpg\" alt=\"\" class=\"wp-image-94217\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlSelectData-1024x512.jpg 1024w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlSelectData-300x150.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlSelectData-768x384.jpg 768w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlSelectData.jpg 1091w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>Fig 3.  Data in the tables &#8211; student and volunteer<\/figcaption><\/figure>\n<h3 class=\"wp-block-heading\" id=\"h-3-3-using-the-insert-into-select-statement\">3.3 Using the Insert Into Select Statement <\/h3>\n<p>Now, we are going to use the insert into a select statement to copy of details of Indian students in the student table to the volunteer table. <\/p>\n<p>You can clearly see that before using the insert into a select statement, the volunteer table has 3 rows. When the Insert Into select statement is used, 1 row (which is the last row in the updated volunteer table) is added. <\/p>\n<p>So, you can see that this statement has no effect either on the existing data in the <code>destination <\/code>table nor on the <code>source <\/code>table. <\/p>\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"582\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlInsertSelect-1024x582.jpg\" alt=\"SQL INSERT INTO SELECT - add the Indian student's details\" class=\"wp-image-94218\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlInsertSelect-1024x582.jpg 1024w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlInsertSelect-300x170.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlInsertSelect-768x436.jpg 768w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/sqlInsertSelect.jpg 1097w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>Fig 4.  Usage of Insert Into Select statement<\/figcaption><\/figure>\n<h2 class=\"wp-block-heading\" id=\"h-4-summary\">4. Summary<\/h2>\n<p>In this example, we learned:<\/p>\n<ol class=\"wp-block-list\">\n<li>The functionality and usage of Insert Into Select statement.<\/li>\n<li>Implementing the functionality using MySQL Command Line Client.<\/li>\n<\/ol>\n<h2 class=\"wp-block-heading\" id=\"h-5-download-the-sql-script\">5. Download the SQL Script<\/h2>\n<p>Download the SQL script comprising of the commands used in the example.<\/p>\n<div class=\"download\"><strong>Download<\/strong><br \/>\nYou can download the full source code of this example here: <a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/09\/insertIntoSelect-1.zip\"><strong>SQL INSERT INTO SELECT STATEMENT Example<\/strong><\/a><\/div>\n<p><strong>Last updated on Nov. 07th, 2021<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we will explain SQL INSERT INTO SELECT Statement through examples. You might have used a &#8216;select&#8217; statement, and the &#8216;insert into&#8217; statement in SQL separately. The select statement is used to fetch data from the database whereas the &#8216;insert into&#8217; statement inserts data into the table. In this particular example, we will &hellip;<\/p>\n","protected":false},"author":234,"featured_media":1204,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[710,46646,46645],"class_list":["post-94137","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-insert","tag-insert-into","tag-select"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL INSERT INTO SELECT Statement - Examples Java Code Geeks<\/title>\n<meta name=\"description\" content=\"The SQL Insert Into Select statement is used to copy the data from one table (the source table) into another table (the destination table).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL INSERT INTO SELECT Statement - Examples Java Code Geeks\" \/>\n<meta property=\"og:description\" content=\"The SQL Insert Into Select statement is used to copy the data from one table (the source table) into another table (the destination table).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/\" \/>\n<meta property=\"og:site_name\" content=\"Examples Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-11T08:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-07T21:43:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Simran Koul\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simran Koul\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/\"},\"author\":{\"name\":\"Simran Koul\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c\"},\"headline\":\"SQL INSERT INTO SELECT Statement Example\",\"datePublished\":\"2020-09-11T08:00:00+00:00\",\"dateModified\":\"2021-11-07T21:43:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/\"},\"wordCount\":608,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"keywords\":[\"insert\",\"insert into\",\"select\"],\"articleSection\":[\"sql\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/\",\"name\":\"SQL INSERT INTO SELECT Statement - Examples Java Code Geeks\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"datePublished\":\"2020-09-11T08:00:00+00:00\",\"dateModified\":\"2021-11-07T21:43:54+00:00\",\"description\":\"The SQL Insert Into Select statement is used to copy the data from one table (the source table) into another table (the destination table).\",\"breadcrumb\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#primaryimage\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"width\":150,\"height\":150,\"caption\":\"Bipartite Graph\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/examples.javacodegeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java Development\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Core Java\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"sql\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"SQL INSERT INTO SELECT Statement Example\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Examples and Code Snippets\",\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/javacodegeeks\",\"https:\/\/x.com\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c\",\"name\":\"Simran Koul\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png\",\"caption\":\"Simran Koul\"},\"description\":\"Simran has graduated as a Bachelor of Engineering in Computer Science from Chitkara University. She has undergone a 6-months long comprehensive industrial training at the reputed Centre for Development of Advanced Computing (C-DAC), where she worked on a project including the likes of Java, JSP, Servlets while the UI-UX through the pioneering HTML, CSS and JS. Her inquisitive nature and the seed of curiosity keeps her on the toes to find material to write about. Along with her interests in Software Development, she is an ardent reader and always ready-to-write writer.\",\"url\":\"https:\/\/examples.javacodegeeks.com\/author\/simran-koul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL INSERT INTO SELECT Statement - Examples Java Code Geeks","description":"The SQL Insert Into Select statement is used to copy the data from one table (the source table) into another table (the destination table).","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:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/","og_locale":"en_US","og_type":"article","og_title":"SQL INSERT INTO SELECT Statement - Examples Java Code Geeks","og_description":"The SQL Insert Into Select statement is used to copy the data from one table (the source table) into another table (the destination table).","og_url":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/","og_site_name":"Examples Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_published_time":"2020-09-11T08:00:00+00:00","article_modified_time":"2021-11-07T21:43:54+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","type":"image\/jpeg"}],"author":"Simran Koul","twitter_card":"summary_large_image","twitter_creator":"@javacodegeeks","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"Simran Koul","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#article","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/"},"author":{"name":"Simran Koul","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c"},"headline":"SQL INSERT INTO SELECT Statement Example","datePublished":"2020-09-11T08:00:00+00:00","dateModified":"2021-11-07T21:43:54+00:00","mainEntityOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/"},"wordCount":608,"commentCount":0,"publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","keywords":["insert","insert into","select"],"articleSection":["sql"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/","url":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/","name":"SQL INSERT INTO SELECT Statement - Examples Java Code Geeks","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#primaryimage"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","datePublished":"2020-09-11T08:00:00+00:00","dateModified":"2021-11-07T21:43:54+00:00","description":"The SQL Insert Into Select statement is used to copy the data from one table (the source table) into another table (the destination table).","breadcrumb":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#primaryimage","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","width":150,"height":150,"caption":"Bipartite Graph"},{"@type":"BreadcrumbList","@id":"https:\/\/examples.javacodegeeks.com\/sql-insert-into-select-statement-example\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/examples.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java Development","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/"},{"@type":"ListItem","position":3,"name":"Core Java","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/"},{"@type":"ListItem","position":4,"name":"sql","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/"},{"@type":"ListItem","position":5,"name":"SQL INSERT INTO SELECT Statement Example"}]},{"@type":"WebSite","@id":"https:\/\/examples.javacodegeeks.com\/#website","url":"https:\/\/examples.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Examples and Code Snippets","publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/examples.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/examples.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c","name":"Simran Koul","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png","caption":"Simran Koul"},"description":"Simran has graduated as a Bachelor of Engineering in Computer Science from Chitkara University. She has undergone a 6-months long comprehensive industrial training at the reputed Centre for Development of Advanced Computing (C-DAC), where she worked on a project including the likes of Java, JSP, Servlets while the UI-UX through the pioneering HTML, CSS and JS. Her inquisitive nature and the seed of curiosity keeps her on the toes to find material to write about. Along with her interests in Software Development, she is an ardent reader and always ready-to-write writer.","url":"https:\/\/examples.javacodegeeks.com\/author\/simran-koul\/"}]}},"_links":{"self":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/94137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/users\/234"}],"replies":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=94137"}],"version-history":[{"count":0,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/94137\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media\/1204"}],"wp:attachment":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=94137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=94137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=94137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}