Batch File & MySQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dbranch - 15 Sep 2007 00:17 GMT

I am using CFExecute to launch a batch file to interact with another
application via the command line. Within the batchfile I would like perform
some logic and one set is to Update a record in MySQL database. Basically what
I want to do is something like this but I know this is the right syntax.

C:\Program Files\MySQL\MySQL Server 5.0\bin\MySQL.exe" -u root -p123456
USE: MyDataBase;
UPDATE candidatejobboard SET SubmissionStatus=3 WHERE JobBoardSubmissionID=39;

Reply to this Message

Dan Bracuk - 15 Sep 2007 11:17 GMT

Somewhere in there you need a connect string. I don't know how to do it with
windows/MySql, but I'll show you how to do it with unix/redbrick. It might
illuminate a light bulb over someone's head.

echo "
your sql goes here
" | risql -d database_name user_name password 2> file_of_your_choice

in that example, risql is the program that connects to the db.

Reply to this Message

dbranch - 15 Sep 2007 19:46 GMT

Dan,

Thanks for the feeback you got me in the right direction. For anyone that
needed the final solution it was
"C:\Program Files\MySQL\MySQL Server 5.0\bin\MySQL.exe" -u root -pt12345 -e
"UPDATE candidatejobboard SET SubmissionStatus=2 WHERE JobBoardSubmissionID=39"
test

Reply to this Message

Webmaster Forum / ColdFusion / Advanced Techniques / September 2007

Batch File & MySQL