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]
