Dear freinds,
I am still getting errors.Load infile script. Guidance , please.
Asif Qureshi
------------------------------------------------------------------------------
---
mysql> describe chicago
-> ;
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| email | varchar(150) | | PRI | | |
+-------+--------------+------+-----+---------+----------------+
2 rows in set (0.02 sec)
mysql> LOAD DATA INFILE
-> 'CHICAGO.TXT' into table
-> B.CHICAGO;
ERROR 1062: Duplicate entry '0-' for key 1
mysql>
