{"id":22551,"date":"2024-03-15T23:47:20","date_gmt":"2024-03-15T23:47:20","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/"},"modified":"2024-03-21T23:09:18","modified_gmt":"2024-03-21T23:09:18","slug":"how-to-import-data-with-empty-values-in-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/","title":{"rendered":"How to import data with empty values in MySQL?"},"content":{"rendered":"<p>When importing data with null values into a MySQL database, you can use the LOAD DATA INFILE statement or use MySQL tools such as MySQL Workbench or phpMyAdmin.<\/p>\n<p>When importing data using the LOAD DATA INFILE statement, you can represent empty values as NULL, for example:<\/p>\n<pre class=\"post-pre\"><code>LOAD DATA INFILE <span class=\"hljs-string\">'path\/to\/file.csv'<\/span>\r\n<span class=\"hljs-keyword\">INTO<\/span> <span class=\"hljs-keyword\">TABLE<\/span> table_name\r\nFIELDS TERMINATED <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-string\">','<\/span> \r\nENCLOSED <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-string\">'\"'<\/span>\r\nLINES TERMINATED <span class=\"hljs-keyword\">BY<\/span> <span class=\"hljs-string\">'\\n'<\/span>\r\n(column1, column2, <span class=\"hljs-variable\">@var1<\/span>)\r\n<span class=\"hljs-keyword\">SET<\/span> column3 <span class=\"hljs-operator\">=<\/span> IF(<span class=\"hljs-variable\">@var1<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">''<\/span>, <span class=\"hljs-keyword\">NULL<\/span>, <span class=\"hljs-variable\">@var1<\/span>);\r\n<\/code><\/pre>\n<p>In the example above, column1 and column2 are columns containing null values, and @var1 is a variable used to store the values of these columns. The SET clause is then used to set column3 to NULL, and if @var1 is an empty string, it will also be set to NULL.<\/p>\n<p>If using MySQL tools like MySQL Workbench or phpMyAdmin, you can directly import data files containing empty values. These tools usually provide options to specify how empty values are represented.<\/p>\n<p>Please ensure that the columns of the target table allow null values before importing data, as failure to do so will result in import failure.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When importing data with null values into a MySQL database, you can use the LOAD DATA INFILE statement or use MySQL tools such as MySQL Workbench or phpMyAdmin. When importing data using the LOAD DATA INFILE statement, you can represent empty values as NULL, for example: LOAD DATA INFILE &#8216;path\/to\/file.csv&#8217; INTO TABLE table_name FIELDS TERMINATED [&hellip;]<\/p>\n","protected":false},"author":10,"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-22551","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"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>How to import data with empty values in MySQL? - 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\/how-to-import-data-with-empty-values-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to import data with empty values in MySQL?\" \/>\n<meta property=\"og:description\" content=\"When importing data with null values into a MySQL database, you can use the LOAD DATA INFILE statement or use MySQL tools such as MySQL Workbench or phpMyAdmin. When importing data using the LOAD DATA INFILE statement, you can represent empty values as NULL, for example: LOAD DATA INFILE &#039;path\/to\/file.csv&#039; INTO TABLE table_name FIELDS TERMINATED [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-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-15T23:47:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T23:09:18+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\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=\"Jackson Davis\" \/>\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-import-data-with-empty-values-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"How to import data with empty values in MySQL?\",\"datePublished\":\"2024-03-15T23:47:20+00:00\",\"dateModified\":\"2024-03-21T23:09:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/\"},\"wordCount\":160,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/\",\"name\":\"How to import data with empty values in MySQL? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T23:47:20+00:00\",\"dateModified\":\"2024-03-21T23:09:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to import data with empty values in MySQL?\"}]},{\"@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\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to import data with empty values in MySQL? - 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\/how-to-import-data-with-empty-values-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"How to import data with empty values in MySQL?","og_description":"When importing data with null values into a MySQL database, you can use the LOAD DATA INFILE statement or use MySQL tools such as MySQL Workbench or phpMyAdmin. When importing data using the LOAD DATA INFILE statement, you can represent empty values as NULL, for example: LOAD DATA INFILE 'path\/to\/file.csv' INTO TABLE table_name FIELDS TERMINATED [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T23:47:20+00:00","article_modified_time":"2024-03-21T23:09:18+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"How to import data with empty values in MySQL?","datePublished":"2024-03-15T23:47:20+00:00","dateModified":"2024-03-21T23:09:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/"},"wordCount":160,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/","name":"How to import data with empty values in MySQL? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T23:47:20+00:00","dateModified":"2024-03-21T23:09:18+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-import-data-with-empty-values-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to import data with empty values in MySQL?"}]},{"@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\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22551","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=22551"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22551\/revisions"}],"predecessor-version":[{"id":56480,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22551\/revisions\/56480"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=22551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=22551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=22551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}