MySQL Forums
Forum List  »  Quality Assurance

AUTO INCREMENT of primary key not working
Posted by: mark roles
Date: November 12, 2012 01:46PM

With the following code successfully executed:

CREATE TABLE `outback`.`JUN7`(
FM_Id int(6) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (FM_Id),
COLOR VARCHAR(10),
SN VARCHAR(10));

I then do a LOAD DATA INFILE of a file that just contains the following:

RED,1234567890

I get the error message of:
Incorrect integer value: 'RED' for column 'FM_ID' at row 1.

What am I missing to have it auto populate my PRIMARY KEY of FM_Id?

Options: ReplyQuote


Subject
Views
Written By
Posted
AUTO INCREMENT of primary key not working
2073
November 12, 2012 01:46PM


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.