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
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
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
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.sql
The statements.sql file should contain full sql