At 8:15 PM -0500 9/22/99, Paul DuBois wrote:
>At 7:58 PM -0500 9/22/99, Martin Ramsch wrote:
>>On Wed, 1999-09-22 19:51:01 -0500, Paul DuBois wrote:
>>> >Not possible with mysqlimport as far as I know, but you always can use
>>> >LOAD DATA LOCAL INFILE directly.
>>>
>>> How would that help? mysqlimport --local is basically the same as
>>> LOAD DATA LOCAL INFILE.
>>
>>Yes, but with LOAD DATA one can specify fields!
>>
>> LOAD DATA LOCAL INFILE 'fielname'
>> INTO TABLE tablename
>> FIELDS TERMINATED BY ' ; '
>> (col3, col6);
>
>From mysqlimport --help:
>
> --fields-terminated-by=...
> Fields in the textfile are terminated by ...
> --fields-enclosed-by=...
> Fields in the importfile are enclosed by ...
> --fields-optionally-enclosed-by=...
> Fields in the i.file are opt. enclosed by ...
> --fields-escaped-by=...
> Fields in the i.file are escaped by ...
> --lines-terminated-by=...
> Lines in the i.file are terminated by ...
>
>
>Am I missing something here?
Ah, yes, I am missing something here. When you were saying "fields",
I was keying on the *field delimiter* part, not that you can specify
a column list.
Duh. :-)
--
Paul DuBois, paul@stripped
