How do I LOAD a text file into a table that has a Primary Key defined?
I have the following table defined:
mysql describe phoneList;
+--+-+--+-+-++
| Field| Type| Null | Key | Default | Extra |
the
table again to add the ID field
Alan
-Original Message-
From: Chris Walcott [mailto:cwalcott;macromedia.com]
Sent: Thursday, 14 November 2002 9:42
To: Mysql-L (E-mail)
Subject: trouble with LOAD command
How do I LOAD a text file into a table that has a Primary Key defined?
I have
Chris Walcott wrote:
How do I LOAD a text file into a table that has a Primary Key defined?
Most stuff snipped. Sorry :)
I drop the Primary Key (and Timestamp) when I use 'load data infile'.
Below is my VB code which I use in Access to import stuff into MySQL.
Maybe someone will find it