Re: importing text file with mysqlimport

[Paul DuBois]

At 7:47 PM -0500 9/22/99, Martin Ramsch wrote:
>On Wed, 1999-09-22 14:45:09 -0400, Bob C. Ruddy wrote:
>> I didn't see anyway of specifying what table to put the data in.
>
>| $ mysqlimport --help
>| mysqlimport  Ver 1.3 Distrib 3.22.19b, for sun-solaris2.6 (sparc)
>| Monty & Jani. This software is in public Domain
>| This software comes with ABSOLUTELY NO WARRANTY
>|
>| Loads tables from text files in various formats.  The base name of the
>| text file must be the name of the table that should be used.
>
>See last sentence ... :)
>
>> But how would I enter a two feild text file into a table with say 6
>> feilds and get all the data into the correct fields?
>
>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.

--
Paul DuBois, paul@stripped