MySQL Forums
Forum List  »  Newbie

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

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

What can it be ?

Thank you.

Options: ReplyQuote


Subject
Written By
Posted
load data local infile - error in first column only in first row
May 24, 2017 08:20AM


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.