Hi Joel
Actually yes!!
It has to be of sql syntax, so if you have
a .cvs you'll have to ro a find replace like
this:
s/\n/');\nINSERT INTO MY_TABLE( myvalue1, myvalue2, myvalue3, .., myvaluen )
values ( '/g;
s/;/','/;
SO THAT
34;4356;346;346346;34636
35;4;4;34;34
BECOMES:
');
INSERT INTO MY_TABLE( myvalue1, myvalue2, myvalue3, .., myvaluen ) values
( '34,4356,346,346346,34636');
INSERT INTO MY_TABLE( myvalue1, myvalue2, myvalue3, .., myvaluen ) values
( '35,4,4,34,34');
INSERT INTO MY_TABLE( myvalue1, myvalue2, myvalue3, .., myvaluen ) values
( '
Then cut off the starting '); and the last INSERTline (which doesn't contain
any walues)
then you have something you can feed mysql with
(this you can do with Ultraedit, but there is maybe some prog you can use to
convert this for you;
this is my way of getting values in )
mvh:
Pål Wester, programmerer
never.no as, stortingsgt 30, 0161 Oslo
tlf: 22 01 66 20, fax: 22 01 66 21
direkte: 22 01 66 34, 906 900 62
http://never.no - icq:103476059
~ f u cn rd ts u prb a gk ~
> -----Opprinnelig melding-----
> Fra: Joel Holtzman [mailto:[EMAIL PROTECTED]]
> Sendt: 12. februar 2001 23:15
> Til: Rus
> Kopi: [EMAIL PROTECTED]
> Emne: Re: CREATE TABLE / Telnet (Linux / Unix server)
>
>
> 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
---------------------------------------------------------------------
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
