LOAD DATA LOCAL INFILE field substring
When i use LOAD DATA LOCAL INFILE to import data to mysql,one column in table defined as varchar(20),but in some records,this column's length are larger then 20,it won't report an exception but truncate the string and left 20 characters into table.It's this mysql's configuration and how can i make it report an exception?
Subject
Written By
Posted
LOAD DATA LOCAL INFILE field substring
November 13, 2018 01:24AM
November 13, 2018 09:54AM
November 14, 2018 03:15AM
November 14, 2018 11:50AM
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.