Auto Increment with LOAD DATA INFILE

[thingy]

Hi,

I'm using LOAD DATA INFILE to populate a MySQL db table with values from a textfile. The textfile does not have an empty column I can use to add auto increment.

Is there a way to add auto increment without editing the textfile or going back into my table and adding an extra filed for the auto increment after the table has been updated?

Thanks

[coopster]

Welcome to WebmasterWorld, thingy.

I usually use the null value (\N) in cases such as this.

When reading data with LOAD DATA INFILE, empty or missing columns are updated with ''. If you want a NULL value in a column, you should use \N in the data file. The literal word ``NULL'' may also be used under some circumstances. See Section 13.1.5, “LOAD DATA INFILE Syntax”.

Resource:
[dev.mysql.com...]

[thingy]

Thanks Coopster, it worked perfectly!