: 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
David McBride [EMAIL PROTECTED] writes:
Thanks so much, that did the trick.
I really appreciate the mercy on a poor newbie.
David,
You're quite welcome. Now if I could find an employer willing
to pay me for utilizing the 23 years of knowledge I used to provide
such a solution :)
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
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 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
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
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
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