mysql> show columns from zip; +----------+------------------+------+-----+---------+----------------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+------------------+------+-----+---------+----------------+---------------------------------+ | id | int(10) unsigned | | PRI | NULL | auto_increment | select,insert,update,references | | extra1 | char(5) | YES | | NULL | | select,insert,update,references | | zip5 | char(5) | YES | | NULL | | select,insert,update,references | | zip7 | char(7) | YES | | NULL | | select,insert,update,references | | extra4 | char(14) | YES | | NULL | | select,insert,update,references | | extra5 | char(44) | YES | | NULL | | select,insert,update,references | | extra6 | char(154) | YES | | NULL | | select,insert,update,references | | prefname | char(8) | YES | | NULL | | select,insert,update,references | | city | char(20) | YES | | NULL | | select,insert,update,references | | street | char(74) | YES | | NULL | | select,insert,update,references | | extra10 | tinyint(4) | YES | | NULL | | select,insert,update,references | | extra11 | tinyint(4) | YES | | NULL | | select,insert,update,references | | extra12 | tinyint(4) | YES | | NULL | | select,insert,update,references | | extra13 | tinyint(4) | YES | | NULL | | select,insert,update,references | | extra14 | tinyint(4) | YES | | NULL | | select,insert,update,references | | extra15 | tinyint(4) | YES | | NULL | | select,insert,update,references | +----------+------------------+------+-----+---------+----------------+---------------------------------+ 16 rows in set (0.01 sec) mysql> load data local infile '/home/tommy/tmp/ken_all.txt' into table zip fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' (extra1,zip5,zip7,extra4,extra5,extra6,prefname,city,street,extra10,extra11,extra12,extra13,extra14,extra15); Query OK, 120018 rows affected (31.19 sec) Records: 120018 Deleted: 0 Skipped: 0 Warnings: 0 mysql>