Iniciar mysql via shh
load data local infile 'base.csv' into table base FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Si no se exportan correctamente las líneas probar cambiar:
LINES TERMINATED BY '\r'; o LINES TERMINATED BY '\r\n';
No hay comentarios:
Publicar un comentario