Date: 07/25/06 (MySQL Communtiy)    Keywords: mysql, database, sql

hi all

I'm trying to import data into a table with a column that has AUTO_INCREMENT:

MYSQL> desc stats;
+-------+---------------------+------+-----+---------+----------------+
| Field | Type                | Null | Key | Default | Extra          |
+-------+---------------------+------+-----+---------+----------------+
| id    | bigint(20) unsigned |      | PRI | NULL    | auto_increment |
| date  | bigint(14) unsigned | YES  |     | NULL    |                |
| ent1  | varchar(10)         |      |     |         |                |
| ent2  | varchar(10)         |      |     |         |                |
+-------+---------------------+------+-----+---------+----------------+

LOAD DATA INFILE "stats.txt" INTO TABLE stats (date, ent1, ent2);
Query OK, 140 rows affected (0.01 sec)
Records: 140  Deleted: 0  Skipped: 0  Warnings: 0

+------+----------------+------------+------------+
| id   | date           | prid       | did        |
+------+----------------+------------+------------+
          
| 3870 | 20060725133314 | FFFFFFFFFF | f111111111 |
| 3871 | 20060725133613 | FCCCCCCCCC | f222222222 |
| 3872 | 20060725133722 | FDDDDDDDDD | d333333333 |
|  0   | 20060704011139 | FVVVVVVVVV | e111111111 |
|  0   | 20060704104952 | LSSSSSSSSS | f222222222 |
          
|  0   | 20060720161936 | FDDDDDDDDD | d111111111 |
+------+----------------+------------+------------+

Source: http://community.livejournal.com/mysql/100368.html