What is the current value for you id field? Approximately how many records
are you inserting?
-----Original Message-----
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/20/04 3:16 AM
Subject: load data infile
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>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
