Chris Walcott wrote:
How do I LOAD a text file into a table that has a Primary Key defined?
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 useful.
The point is that you h
file, then atlter 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 i
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 |
+--+--
