RE: load data help

[David McBride]

Thanks so much, that did the trick.
I really appreciate the mercy on a poor newbie.

Thanks again,
David

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 5:28 PM
To: David McBride
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: load data help 


My question is, how can I take a log file that has 25 columns of data and
tell mysql to only load column 1, column 3, and column 7 from the raw log
file?

 I'm not sure mysql can do this.  I'd be more inclined to use cut
on a Linux system in the following fashion:

cut -d ' ' -f 1,3,7 in.dat out.dat

then use out.dat as the file spec for the 'Load Data INFILE'
   Brad Eacker ([EMAIL PROTECTED])



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: load data help

[David McBride]

Thanks for the reply.  I was a little confussed on the exact defintion of a line, I 
thought it meant a whole row of data.
The space seperated fields worked great, but still gave me the error:
ERROR 1054: Unknown column 'col1' in 'field list'
I could not find anywhere on how to define the field list.
Thanks again,
David


David McBride writes:
I need to load data from a log file.  The file is a space seperated
file.  I can already ignore the first 7 lines (that are commnet lines),
but what I can not seem to do is:
1. get load data to use the space seperated format.
2. only load certain columns.  

I tried: mysql LOAD DATA INFILE 'persondata.txt'
-   INTO TABLE persondata (col1,col2,...);

David,
 Based upon the manual for 4.0.17 the following syntax would fit
your description:

LOAD DATA INFILE 'persondata.txt'
INTO TABLE persondata
FIELDS TERMINATED by ' '
(col1,col2,...);

You may need the LOCAL key word if you want the client to read the
data file.
Brad Eacker ([EMAIL PROTECTED])



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: load data help

[David McBride]

I fugured out that I needed to put (name of col1, name of col2) instead of (col1, 
col2).
Duhh   Sorry
My question is, how can I take a log file that has 25 columns of data and tell mysql 
to only load column 1, column 3, and column 7 from the raw log file?

Sorry for being so dense.

Thanks,
David


David McBride writes:
I need to load data from a log file.  The file is a space seperated
file.  I can already ignore the first 7 lines (that are commnet lines),
but what I can not seem to do is:
1. get load data to use the space seperated format.
2. only load certain columns.  

I tried: mysql LOAD DATA INFILE 'persondata.txt'
-   INTO TABLE persondata (col1,col2,...);

David,
 Based upon the manual for 4.0.17 the following syntax would fit
your description:

LOAD DATA INFILE 'persondata.txt'
INTO TABLE persondata
FIELDS TERMINATED by ' '
(col1,col2,...);

You may need the LOCAL key word if you want the client to read the
data file.
Brad Eacker ([EMAIL PROTECTED])



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

load data help

[David McBride]

I need to load data from a log file.  The file is a space seperated file.  I can 
already ignore the first 7 lines (that are commnet lines), but what I can not seem to 
do is:
1. get load data to use the space seperated format.
2. only load certain columns.  

I tried: mysql LOAD DATA INFILE 'persondata.txt'
-   INTO TABLE persondata (col1,col2,...);

But it gives me an error about field lists.  I can not find anything about defining 
field lists in the manual.

Thanks for your time
David


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]