MySQL Forums
Forum List  »  General

Re: MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column
Posted by: Peter Brawley
Date: November 20, 2019 12:02PM

Again the Load Data input string "0 PGEN_TEST.19TXT_000 0 0 20191119 0 0 1 0 10:55:39 0 0 000 1" doesn't match the Create Table definition ...

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
`COUNT` varchar(5) NOT NULL,                     -- 0
`DATE_IN` varchar(8) NOT NULL,                   -- 20191119
`DATE_PROD` varchar(8) NOT NULL,                 -- 0
`STATUS` int(10) unsigned NOT NULL,              -- 0
`GENERATION` char(1) NOT NULL,                   -- 1
`START_REC` int(10) unsigned NOT NULL,           -- 0
`END_REC` int(10) unsigned NOT NULL,             -- 10:55:39 (NOT AN INT)
`NOTE` varchar(255) NOT NULL,                    -- 0
`DATE_DISPATCH` varchar(8) NOT NULL,             -- 0
`TIME_IN` varchar(8) NOT NULL,                   -- 000
`TIME_PROD` varchar(8) NOT NULL,                 -- 1
`TIME_DISPATCH` varchar(8) NOT NULL,             -- (MISSING VALUE)
`SCRAPS` int(10) unsigned NOT NULL,              -- (MISSING VALUE)
`FSTATUS` int(10) unsigned NOT NULL DEFAULT '0', -- (MISSING VALUE)
`TMPL_ID` varchar(3) NOT NULL DEFAULT '0',       -- (MISSING VALUE)
`INST_ID` int(10) unsigned NOT NULL DEFAULT '0', -- (MISSING VALUE)

As the Load Data manual page says, skipping columns requires a column list.

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.