MySQL Forums
Forum List  »  MySQL Workbench

load data local infile - error in first column only in first row
Posted by: Daniel Cavalcante Scalisse Daniel
Date: May 24, 2017 09:12AM

I have a table where the first column is of type int.
It happens that only in the first line and in the first column, it changes the value of the file by zero, generating a warning that it is not a number.

Following table:
Table Import
(
Id int,
Name varchar (50),
Email varchar (50)
)

File.txt:
1|Daniel|daniel_scalisse@yahoo.com.br
2|Maria|maria.silva@hotmail.com
3| Michael.michael@gmail.com

Result of import:
0 - Daniel - daniel_scalisse@yahoo.com.br
2 - Maria - maria.silva@hotmail.com
3 - Michael - michael@gmail.com

Command:
load data local infile 'C:\Files\ImpData.txt'
into table Client CHARACTER SET utf8
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\r\n';

What can it be ?

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
load data local infile - error in first column only in first row
754
May 24, 2017 09:12AM


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.