Re: Problem adding auto increment with csv import
An auto_increment column should be int/mediumint/bigint unsigned, never double since floats & doubles have rounding errors and auto_inc does not use decimals. Consider reading the manual pages on primary keys and auto_increment.
"I searched the web and this forum for a solution, and I've tried all of the suggestions without success" is surprising. Googling for "auto_increment, load data infile" gets 42,800 hits, some of which you evidently missed, most of which say to omit the auto_inc column from the column list, and set it=null like so ...
load ...
(a,b,c,d,...)
set ID=null
Subject
Written By
Posted
September 09, 2014 08:44AM
Re: Problem adding auto increment with csv import
September 09, 2014 09:41AM
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.