Re: MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column

[Anton Bracjun]

Hi Peter,
Please look at the data with TAB characters replaced by * and windows EoL marked as CRLF

0*PGEN_TEST.19TXT_000*0*0*20191119**0*0*1*0***10:55:39***0*0*000*1CRLF

There I would see it like this>

CREATE TABLE `palajjobs` (
`SEQ` int(10) unsigned NOT NULL DEFAULT '0', -- 0 (PK VALUE WILL BE VALID ONLY ONCE)
`JOB_ID` varchar(25) NOT NULL, -- PGEN_TEST.19TXT_000
`JID` int(10) unsigned NOT NULL DEFAULT '0', -- 0 --> MySQL produces error on this column?!?
`COUNT` varchar(5) NOT NULL, -- 0
`DATE_IN` varchar(8) NOT NULL, -- 20191119
`DATE_PROD` varchar(8) NOT NULL, -- NULL/Empty
`STATUS` int(10) unsigned NOT NULL, -- 0
`GENERATION` char(1) NOT NULL, -- 0
`START_REC` int(10) unsigned NOT NULL, -- 1
`END_REC` int(10) unsigned NOT NULL, -- 0
`NOTE` varchar(255) NOT NULL, -- NULL/Empty
`DATE_DISPATCH` varchar(8) NOT NULL, -- NULL/Empty
`TIME_IN` varchar(8) NOT NULL, -- 10:55:39
`TIME_PROD` varchar(8) NOT NULL, -- NULL/Empty
`TIME_DISPATCH` varchar(8) NOT NULL, -- NULL/Empty
`SCRAPS` int(10) unsigned NOT NULL, -- 0
`FSTATUS` int(10) unsigned NOT NULL DEFAULT '0', -- 0
`TMPL_ID` varchar(3) NOT NULL DEFAULT '0', -- 000
`INST_ID` int(10) unsigned NOT NULL DEFAULT '0', -- 1
-- CRLF, end of record/row 1