G'day all
I'm trying to run a connection and query from one line (it will eventually
be called as part of a 'do shell script' Applescript on Mac OSX)
The connection works fine:
/library/mysql/bin/mysql -uroot -ppassword mydatabase
And then I want to load a file using:
load data infile
Kim Kohen [EMAIL PROTECTED] wrote:
I'm trying to run a connection and query from one line (it will eventually
be called as part of a 'do shell script' Applescript on Mac OSX)
The connection works fine:
/library/mysql/bin/mysql -uroot -ppassword mydatabase
And then I want to load a file
G'day Victoria
You can use mysql in a batch mode like:
mysql -e LOAD_DATA_command_here
That's perfect, thanks. Exactly what I was looking for and now up and
running.
Cheers and thanks again
kim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
