{"id":47,"date":"2009-02-27T13:06:48","date_gmt":"2009-02-27T17:06:48","guid":{"rendered":"http:\/\/blog.espol.edu.ec\/xallam\/?p=47"},"modified":"2009-02-27T13:06:48","modified_gmt":"2009-02-27T17:06:48","slug":"mysql-csv","status":"publish","type":"post","link":"https:\/\/blog.espol.edu.ec\/xallam\/2009\/02\/27\/mysql-csv\/","title":{"rendered":"Importar datos delimitados a MySQL"},"content":{"rendered":"<p>A continuaci\u00f3n se detallan los pasos para importar datos en BD MySQL:<\/p>\n<p>Primero, habr\u00e1 que pasar el archivo a la ubicaci\u00f3n donde se encuentra <strong>mysql.exe<\/strong>.<\/p>\n<p>Luego, es cuesti\u00f3n de abrir <strong>mysql command line<\/strong> y digitar:<\/p>\n<blockquote>\n<p style=\"text-align: left\">LOAD DATA <strong>LOCAL <\/strong>INFILE \u00b4<em>&lt;archivo.csv&gt;<\/em>\u00b4<br \/>\nINTO TABLE <em>&lt;schema&gt;.&lt;table&gt;<br \/>\n<\/em>FIELDS TERMINATED BY ','\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &lt;-----\u00a0 <em>Caracter para separar los campos<br \/>\n<\/em>LINES TERMINATED BY <em>'\\n' \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 &lt;----- \u00a0Caracter para separar la siguiente fila<br \/>\n<\/em> (<em>&lt;campo1&gt;<\/em>, <em>&lt;campo2&gt;<\/em>, <em>&lt;campo3&gt;<\/em> ... );<\/p>\n<p style=\"text-align: left\">\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>A continuaci\u00f3n se detallan los pasos para importar datos en BD MySQL: Primero, habr\u00e1 que pasar el archivo a la ubicaci\u00f3n donde se encuentra mysql.exe. Luego, es cuesti\u00f3n de abrir mysql command line y digitar: LOAD DATA LOCAL INFILE \u00b4&lt;archivo.csv&gt;\u00b4 &hellip; <a href=\"https:\/\/blog.espol.edu.ec\/xallam\/2009\/02\/27\/mysql-csv\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[2838,4777],"class_list":["post-47","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-datos","tag-mysql"],"_links":{"self":[{"href":"https:\/\/blog.espol.edu.ec\/xallam\/wp-json\/wp\/v2\/posts\/47","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.espol.edu.ec\/xallam\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.espol.edu.ec\/xallam\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.espol.edu.ec\/xallam\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.espol.edu.ec\/xallam\/wp-json\/wp\/v2\/comments?post=47"}],"version-history":[{"count":2,"href":"https:\/\/blog.espol.edu.ec\/xallam\/wp-json\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":49,"href":"https:\/\/blog.espol.edu.ec\/xallam\/wp-json\/wp\/v2\/posts\/47\/revisions\/49"}],"wp:attachment":[{"href":"https:\/\/blog.espol.edu.ec\/xallam\/wp-json\/wp\/v2\/media?parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.espol.edu.ec\/xallam\/wp-json\/wp\/v2\/categories?post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.espol.edu.ec\/xallam\/wp-json\/wp\/v2\/tags?post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}