Re: Importing issues

[Peter Brawley]

> I'm wondering if it's possible for MySQL to auto add a primary key during the import process.

No, and that would be a design error. A table isn't a real table without a primary key, and the time to create it is when the table is created.

> The date is recorded as DD-MM-YYY, and the MySQL format is YYYY-MM-DD.
> Is it possible at all to get MySQL to recognize any other format?

Not for storage. Use str_to_date() to massage non-compliant date values, eg ...

load data infile ...
...
( ... @mydatevar ...)
...
set mydatecolname=str_to_date(@mydatevar, "%d-%m-%Y");