Stembridge,
Thursday, March 21, 2002, 12:05:31 AM, you wrote:
Seoen> The problem isn't inserting table schema/data - I know how to do that.
Seoen> I'm referring to the process of inserting an actual FILE (txt, .bat, .jpg)
Seoen> via command line. And of pulling it out and giving it a name (te
n [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 20, 2002 2:34 PM
> To: Stembridge, Michael
> Cc: [EMAIL PROTECTED]
> Subject: Re: Inserting files from command prompt
>
>
> I do this from the command line sometimes:
>
> mysql -h HOST -pPASSWORD DATABASE < statements.s
I do this from the command line sometimes:
mysql -h HOST -pPASSWORD DATABASE < statements.sql
The statements.sql file should contain full sql statements. This will
read in the file and execute the sql 1 line at a time.
The opposite would be to use mysqldump like so:
mysqldump -h HOST -pPASSW
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 appropr
