{"id":12548,"date":"2024-03-14T16:05:41","date_gmt":"2024-03-14T16:05:41","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/"},"modified":"2025-08-05T03:05:15","modified_gmt":"2025-08-05T03:05:15","slug":"what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/","title":{"rendered":"MySQL INSERT INTO SELECT: Copy Data Easily"},"content":{"rendered":"<p>In MySQL, the SELECT INSERT statement is used to select data from one table and insert it into another table. The syntax is as follows:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> table2 (column1, column2, ...)\r\n<span class=\"hljs-keyword\">SELECT<\/span> column1, column2, ...\r\n<span class=\"hljs-keyword\">FROM<\/span> table1\r\n<span class=\"hljs-keyword\">WHERE<\/span> <span class=\"hljs-keyword\">condition<\/span>;\r\n<\/code><\/pre>\n<p>This statement selects data that meet the conditions from table1 and inserts them into table2. It can be used to copy data from one table to another or insert query results into a table.<\/p>\n<p>For example, we have two tables, people and new_people, with the same column names and data types. We can use a SELECT INSERT statement to copy the data from the people table where the age is over 30 to the new_people table.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> new_people (name, age)\r\n<span class=\"hljs-keyword\">SELECT<\/span> name, age\r\n<span class=\"hljs-keyword\">FROM<\/span> people\r\n<span class=\"hljs-keyword\">WHERE<\/span> age <span class=\"hljs-operator\">&gt;<\/span> <span class=\"hljs-number\">30<\/span>;\r\n<\/code><\/pre>\n<p>This will select the data that meets the conditions in the people table and insert their name and age columns into the new_people table.<\/p>\n<p>In conclusion, the SELECT INSERT statement can help us to select and insert data, thereby achieving functions such as data duplication, migration, and importation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In MySQL, the SELECT INSERT statement is used to select data from one table and insert it into another table. The syntax is as follows: INSERT INTO table2 (column1, column2, &#8230;) SELECT column1, column2, &#8230; FROM table1 WHERE condition; This statement selects data that meet the conditions from table1 and inserts them into table2. It [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[15754,513,7988,298,1012],"class_list":["post-12548","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-data-copy","tag-database-management","tag-insert-into-select","tag-mysql","tag-sql-commands"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL INSERT INTO SELECT: Copy Data Easily - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to use MySQL INSERT INTO SELECT to copy data between tables. Syntax and examples included.\" \/>\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-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL INSERT INTO SELECT: Copy Data Easily\" \/>\n<meta property=\"og:description\" content=\"Learn how to use MySQL INSERT INTO SELECT to copy data between tables. Syntax and examples included.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/\" \/>\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-14T16:05:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T03:05:15+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin Taylor\" \/>\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=\"Benjamin Taylor\" \/>\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-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/\"},\"author\":{\"name\":\"Benjamin Taylor\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\"},\"headline\":\"MySQL INSERT INTO SELECT: Copy Data Easily\",\"datePublished\":\"2024-03-14T16:05:41+00:00\",\"dateModified\":\"2025-08-05T03:05:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/\"},\"wordCount\":158,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Data Copy\",\"Database Management\",\"INSERT INTO SELECT\",\"MySQL\",\"SQL commands\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/\",\"name\":\"MySQL INSERT INTO SELECT: Copy Data Easily - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T16:05:41+00:00\",\"dateModified\":\"2025-08-05T03:05:15+00:00\",\"description\":\"Learn how to use MySQL INSERT INTO SELECT to copy data between tables. Syntax and examples included.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL INSERT INTO SELECT: Copy Data Easily\"}]},{\"@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\/ac801fe9549a25960ce48aa2e0a691c9\",\"name\":\"Benjamin Taylor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"caption\":\"Benjamin Taylor\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL INSERT INTO SELECT: Copy Data Easily - Blog - Silicon Cloud","description":"Learn how to use MySQL INSERT INTO SELECT to copy data between tables. Syntax and examples included.","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-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"MySQL INSERT INTO SELECT: Copy Data Easily","og_description":"Learn how to use MySQL INSERT INTO SELECT to copy data between tables. Syntax and examples included.","og_url":"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T16:05:41+00:00","article_modified_time":"2025-08-05T03:05:15+00:00","author":"Benjamin Taylor","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Benjamin Taylor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/"},"author":{"name":"Benjamin Taylor","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9"},"headline":"MySQL INSERT INTO SELECT: Copy Data Easily","datePublished":"2024-03-14T16:05:41+00:00","dateModified":"2025-08-05T03:05:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/"},"wordCount":158,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Data Copy","Database Management","INSERT INTO SELECT","MySQL","SQL commands"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/","name":"MySQL INSERT INTO SELECT: Copy Data Easily - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T16:05:41+00:00","dateModified":"2025-08-05T03:05:15+00:00","description":"Learn how to use MySQL INSERT INTO SELECT to copy data between tables. Syntax and examples included.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-purpose-of-using-the-select-and-insert-statements-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL INSERT INTO SELECT: Copy Data Easily"}]},{"@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\/ac801fe9549a25960ce48aa2e0a691c9","name":"Benjamin Taylor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","caption":"Benjamin Taylor"},"url":"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12548","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=12548"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12548\/revisions"}],"predecessor-version":[{"id":156347,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12548\/revisions\/156347"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=12548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=12548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=12548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}