June 26th, 2007
Importar datos CSV a MySQL
Cuando se quieren importar un conjunto de datos a MySQL, lo mas facil es hacerlo via un archivo CSV usando LOAD DATA
LOAD DATA INFILE 'file_name‘ INTO TABLE tbl_name CHARACTER SET charset_name
FIELDS TERMINATED BY ‘string‘ LINES TERMINATED BY ‘string‘;
Ejemplo:
LOAD DATA INFILE 'data.csv' INTO TABLE tbl_test CHARACTER SET latin1
FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n';
Referencia: Manual MySQL > 11.2.5. LOAD DATA INFILE Syntax
No Comments Add your own
Leave a Reply
XHTML: You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>