Re: Inserting files from command prompt

[Paul DuBois]

At 10:48 -0500 3/20/02, Stembridge, Michael wrote:
>Can a file be inserted to a mysql table from a unix(linux) command prompt?

mysqlimport?

>Also, can I query the same table and output the data to a filename.ext in a
>specified directory?

SELECT ... INTO OUTFILE

>Not sure if this is an appropriate question for the list, but all
>clues/examples would be greatly appreciated.