MySQL Forums
Forum List  »  General

LOAD DATA LOCAL INFILE field substring
Posted by: silence Year
Date: November 13, 2018 01:24AM

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?

Options: ReplyQuote

Written By
LOAD DATA LOCAL INFILE field substring
November 13, 2018 01:24AM

Sorry, only registered users may post in this forum.

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.