MySQL Forums
Forum List  »  Other Migration

Error on id column
Posted by: John Hamm
Date: February 28, 2007 01:59PM

I received this error after LOAD INFILE ...

1366 Incorrect integer value: " for column 'id' at row 1

and again for each row.

my data looks like:

@"2007-01-01"@3@"BBHORU"@"LAM"@"CF PLAID 8 X 11 TALL"@"LINED"@"STPLD"@1@8.75@4.25

and table structure:

CREATE TABLE `esas`.`lineitems` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`month` DATE NOT NULL DEFAULT 0,
`item` VARCHAR(5) NOT NULL DEFAULT '',
`dsc` VARCHAR(6) NOT NULL DEFAULT '',
`vendor` VARCHAR(3) NOT NULL DEFAULT '',
`description` VARCHAR(40) NOT NULL DEFAULT '',
`attr` VARCHAR(15) DEFAULT '',
`size` VARCHAR(15) DEFAULT '',
`qty` INTEGER NOT NULL DEFAULT 0,
`price` FLOAT NOT NULL DEFAULT 0,
`cost` FLOAT NOT NULL DEFAULT 0,
PRIMARY KEY (id)
)
ENGINE = InnoDB;

The actual LOAD syntax I used:

LOAD DATA LOCAL INFILE '~/rpro/csv_files/rpli0701b.csv'
INTO TABLE lineitems
FIELDS TERMINATED BY '@'
ENCLOSED BY '"'
IGNORE 1 LINES;

The actual data loaded into the table looks fine but I am afraid to go too much further with this error. Should I be worried?

--John

Options: ReplyQuote


Subject
Views
Written By
Posted
Error on id column
6054
February 28, 2007 01:59PM
2933
November 27, 2007 07:19AM


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.