{"id":7393,"date":"2024-03-14T05:28:58","date_gmt":"2024-03-14T05:28:58","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/"},"modified":"2025-08-02T15:37:28","modified_gmt":"2025-08-02T15:37:28","slug":"how-to-use-the-select-into-outfile-statement-in-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/","title":{"rendered":"MySQL SELECT INTO OUTFILE: Export Data to Files"},"content":{"rendered":"<p>In MySQL, the SELECT INTO OUTFILE statement is used to export query results to a file. The basic syntax for using this statement is as follows:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> column1, column2, ...\r\n<span class=\"hljs-keyword\">INTO<\/span> OUTFILE <span class=\"hljs-string\">'file_path'<\/span>\r\n<span class=\"hljs-keyword\">FROM<\/span> table_name\r\n<span class=\"hljs-keyword\">WHERE<\/span> <span class=\"hljs-keyword\">condition<\/span>;\r\n<\/code><\/pre>\n<p>In this case, column1, column2, &#8230; are the names of the columns to be selected, &#8216;file_path&#8217; is the file path to export to, table_name is the name of the table to query, and condition is the optional query condition.<\/p>\n<p>For example, to export all data in the table to a file named output.csv, you can use the following query:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span>\r\n<span class=\"hljs-keyword\">INTO<\/span> OUTFILE <span class=\"hljs-string\">'\/path\/to\/output.csv'<\/span>\r\n<span class=\"hljs-keyword\">FROM<\/span> table_name;\r\n<\/code><\/pre>\n<p>Please note that when using the SELECT INTO OUTFILE statement, make sure that the MySQL server has write permissions to the specified file path. Additionally, the exported file will be saved on the MySQL server, not on the client computer.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In MySQL, the SELECT INTO OUTFILE statement is used to export query results to a file. The basic syntax for using this statement is as follows: SELECT column1, column2, &#8230; INTO OUTFILE &#8216;file_path&#8217; FROM table_name WHERE condition; In this case, column1, column2, &#8230; are the names of the columns to be selected, &#8216;file_path&#8217; is the [&hellip;]<\/p>\n","protected":false},"author":12,"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":[1088,995,298,9438,569],"class_list":["post-7393","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-data-export","tag-database-export","tag-mysql","tag-select-into-outfile","tag-sql-tutorial"],"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 SELECT INTO OUTFILE: Export Data to Files - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to use MySQL&#039;s SELECT INTO OUTFILE statement to export query results to files. Complete syntax guide with examples.\" \/>\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\/how-to-use-the-select-into-outfile-statement-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL SELECT INTO OUTFILE: Export Data to Files\" \/>\n<meta property=\"og:description\" content=\"Learn how to use MySQL&#039;s SELECT INTO OUTFILE statement to export query results to files. Complete syntax guide with examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-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-14T05:28:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T15:37:28+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\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=\"Liam\" \/>\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\/how-to-use-the-select-into-outfile-statement-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"MySQL SELECT INTO OUTFILE: Export Data to Files\",\"datePublished\":\"2024-03-14T05:28:58+00:00\",\"dateModified\":\"2025-08-02T15:37:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/\"},\"wordCount\":135,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"data export\",\"Database Export\",\"MySQL\",\"SELECT INTO OUTFILE\",\"sql tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/\",\"name\":\"MySQL SELECT INTO OUTFILE: Export Data to Files - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T05:28:58+00:00\",\"dateModified\":\"2025-08-02T15:37:28+00:00\",\"description\":\"Learn how to use MySQL's SELECT INTO OUTFILE statement to export query results to files. Complete syntax guide with examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL SELECT INTO OUTFILE: Export Data to Files\"}]},{\"@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\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL SELECT INTO OUTFILE: Export Data to Files - Blog - Silicon Cloud","description":"Learn how to use MySQL's SELECT INTO OUTFILE statement to export query results to files. Complete syntax guide with examples.","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\/how-to-use-the-select-into-outfile-statement-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"MySQL SELECT INTO OUTFILE: Export Data to Files","og_description":"Learn how to use MySQL's SELECT INTO OUTFILE statement to export query results to files. Complete syntax guide with examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T05:28:58+00:00","article_modified_time":"2025-08-02T15:37:28+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"MySQL SELECT INTO OUTFILE: Export Data to Files","datePublished":"2024-03-14T05:28:58+00:00","dateModified":"2025-08-02T15:37:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/"},"wordCount":135,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["data export","Database Export","MySQL","SELECT INTO OUTFILE","sql tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/","name":"MySQL SELECT INTO OUTFILE: Export Data to Files - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T05:28:58+00:00","dateModified":"2025-08-02T15:37:28+00:00","description":"Learn how to use MySQL's SELECT INTO OUTFILE statement to export query results to files. Complete syntax guide with examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-select-into-outfile-statement-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL SELECT INTO OUTFILE: Export Data to Files"}]},{"@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\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7393","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\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=7393"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7393\/revisions"}],"predecessor-version":[{"id":152172,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7393\/revisions\/152172"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=7393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=7393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=7393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}