Batch File & MySQL

[dbranch]

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;

[Dan_Bracuk · Accepted solution]

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.

[dbranch]

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