MySQL Forums
Forum List  »  Spanish

LOAD DATA INFILE omite algunos registros
Posted by: Marco Rios
Date: February 24, 2020 02:31PM

Estimados colegas,
estoy tratando de importar una lista de direcciones cotenida en un archivo CSV, en una tabla mediante el comando

LOAD DATA INFILE

sin embargo, el comando está omitiendo algunos algunos registros (solo importa 61 de 120 renglones)
he revisado el archivo CSV y no he encontrado anomalías.

LOAD DATA INFILE '/home/proturs/bak/Ejecutivos de Ventas-FINAL-EXPORT.csv'
	INTO TABLE clie_usuarios 
    FIELDS TERMINATED BY ','  
    LINES STARTING BY '\n'
    (id_cliente, nombre, apellidos, email, email_password, departamento_cc00, puesto_cc00);

Thanks in advance for your valuable help.

Acer LENOVO G450
CPU: Pentium(R) Dual-Core CPU T4400 @ 2.20GHz × 2
RAM: 4GB
Graphics: Intel GM45
OS: UBUNTU 18.04.4 LTS 64bits
GNOME 3.28.2
--
Best regards
Marco
Mexico City, Mexico

Options: ReplyQuote


Subject
Views
Written By
Posted
LOAD DATA INFILE omite algunos registros
793
February 24, 2020 02:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.