Dear Friends,
I am trying to pull lots of data in text file into database table. Their is
single field in table/
The data in text file has been placed in mysql data directory.
Any guidance for this error mysql is giving, please
mysql> use b
Database changed
mysql> LOAD DATA INFILE
-> 'chicago.txt' INTO TABLE
-> b.chicago;
ERROR 1062: Duplicate entry '' for key 2
mysql>
------------------------------------------------------------------------------
-----------------------
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| email | varchar(150) | | PRI | | |
+-------+--------------+------+-----+---------+----------------+
2 rows in set (0.02 sec)
