MySQL Forums
Forum List  »  General

Re: MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column
Posted by: Anton Bracjun
Date: November 21, 2019 05:43AM

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

Options: ReplyQuote




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.