Dear Friends, There are 40 records of email entries in text file which I want to load to table, however, When I enter load data infile 'chicago.txt'into table b.chicago;
I see only 18 rows been updated with output pasted below. Any insight what is happening and guidance, please. mysql> load data infile 'chicago.txt'into table b.chicago; ' for key 1 Duplicate entry '[EMAIL PROTECTED] mysql> table structure mysql> describe chicago; +-------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+-------+ | email | varchar(150) | | PRI | | | +-------+--------------+------+-----+---------+-------+ 1 row in set (0.00 sec) mysql>
