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
The SERVER needs to be able to read the file, and I doubt very much
that mysql has read permissions here.
Jim Bahr wrote:
Hello
I am trying to use the LOAD command and not having much success. My host
company is using version mysql 3.23.51. I am sshing into server,
starting mysql and getting
Jim,
Tuesday, October 01, 2002, 4:01:18 PM, you wrote:
JB I am trying to use the LOAD command and not having much success. My host
JB company is using version mysql 3.23.51. I am sshing into server,
JB starting mysql and getting a mysql prompt. I have a database called
JB login, and have made
Hi,
I just discovered that I have to move the data text file I want to store in
my table into bin directory of mysql directory (c:\mysql\bin\) before
the LOAD DATA local infile text.txt INTO TABLE tabname can work.
The problem here is that how do I then transfer this kind of file from my
On Thu, Dec 13, 2001 at 12:34:59PM -0500, [EMAIL PROTECTED] wrote:
Hi,
I just discovered that I have to move the data text file I want to store in
my table into bin directory of mysql directory (c:\mysql\bin\) before
the LOAD DATA local infile text.txt INTO TABLE tabname can work.
No
Dear All,
I have Mysql server installed at remote site which i need to connect to.
I have tried this from my local computer but didn't work;
c:\mysql\binmysql -h myhost -u myusername -pmypassword
I will also like to use LOAD command to load a text file from my local
computer to the database
Dear All,
I have Mysql server installed at remote site which i need to connect to.
I have tried this from my local computer but didn't work;
c:\mysql\binmysql -h myhost -u myusername -pmypassword
I will also like to use LOAD command to load a text file from my local
computer to the database