I've had questions about this too. What happens if I have a primary key, and
the text file has the columns that are in the existing table, with records.
And I want to insert them. How do I get rid of that duplicate error? I read
the manual, about 'ignore' but I can't get it to work.
Any ideas?
In other words, if I have a db with one table "Test" and columns:
A B
And my file.txt has the columns and records, so it's structured like this:
A B
1 2
3 4
So when I 'load data infile file.txt' the db with 'test' table and 0
records, becomes table with records added.
How do I avoid errors. The manual is no help, I tried it. Any ideas? SHould
I ignore the Primary key field in the text file, and use the rest of it to
avoid that duplicate error? The text file is separated by tabs.
Thanks
Joel
----- Original Message -----
From: Nielsen <[EMAIL PROTECTED]>
To: C.o.m.b.u.s.t. <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday, February 11, 2001 9:24 PM
Subject: RE: CREATE TABLE / Telnet (Linux / Unix server)
> > ...and this will load the table into your database. Now, in the book
> > it doesn't specify whether or not you have to be on the computer with
> > the server, or if you can send the .sql file command from your
> > computer to the remote server, sort of like a file transfer protocol
> > as well. Basically, my question is, do I have to either FTP my files
> > to the server, and then execute the command, or can I do it remotely
> > without FTP? Or is it possible AT ALL to execute the command from a
> > remote computer? In case it helps, I am on a Windows 98 system
> > connected through SSH to an Linux system running Apache. Please
> > help, I'm stuck and I won't give up until I'm un-stuck! Thanks in
> > advance to all that reply.
>
> The file must be on the remote machine (as has been answered), but yes, if
you
> are connected to the shell (via telnet/ssh/ssh2/etc), you can execute the
> command. And, no, the extension may be anything (all you're doing is
> redirecting the contents of the file (via '<') into the 'mysql <database>'
> command.
>
> HTH,
>
> Jon A. Nielsen.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php