Dear friends,

Load data infile 'abcd.txt' into table b.chicago;

This statement loads half of the data from file and gives error posted below.
Any guidance, please.

Thank you.
------------------------------------------------------------------------------
-------

mysql> use b
Database changed
mysql> load data infile 'abcd.txt' into table b.chicago;
' for key 1 Duplicate entry '[EMAIL PROTECTED]
mysql> describe chicago;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| email | varchar(150) |      | PRI |         |       |
+-------+--------------+------+-----+---------+-------+
1 row in set (0.00 sec)

mysql>

Reply via email to