2 Replies Latest reply on Sep 15, 2007 11:46 AM by dbranch

    Batch File & MySQL

      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;

        • 1. Re: Batch File & MySQL
          Dan Bracuk Level 5
          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.
          • 2. Re: Batch File & MySQL
            dbranch Level 1

            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