I turned my access db into excel, and into .csv
So that's the structure of my text file. When I use "Load data infile..."
I get the 10 warnings. 10 for the 2 columns, and 8 records. Does it have to
be a special format? I have the file.txt on the server. I can point to it. I
just can't get it to insert this file's records. Are you saying when columns
exist in a db, you must use Select into?
And does the file need to have columns/records sepearated a certain way?
Mine uses commas. (.csv file)
Thanks
Joel
----- Original Message -----
From: Rus <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 1:21 AM
Subject: Re: CREATE TABLE / Telnet (Linux / Unix server)
>
> Check the structure of txt file. Does it created with SELECT ... INTO
> OUTFILE? Check command syntax.
>
> ----- Original Message -----
> From: Joel Holtzman <[EMAIL PROTECTED]>
> To: Nielsen <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, February 12, 2001 8:51 AM
> Subject: Re: CREATE TABLE / Telnet (Linux / Unix server)
>
>
> > 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
> >
> >
>
>
>
>
>
> ---------------------------------------------------------------------
> 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
