load data local infile - error in first column only in first row
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.
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.