Passing mysql data via cmd line to an .exe?

Passing mysql data via cmd line to an .exe?

am 05.03.2006 06:55:38 von Serpico

I have an Windows .exe that I need to pass flags to that would be data
pulled from a mysql DB. This exe file with args will be automatically
run via the task scheduler. That part I can do. :)

Example: someapp.exe -pid -cid -sid

pid, cid, and sid are arguments that are currently stored in a mysql
DB. I expect a shell script would be the way to go, but I haven't
written one in years.

I suspect the shell script would query the DB, then pass the args to
someapp.exe

1: How would I query the DB via a shell script?
2: How would I pass the resultant data retreived to someapp.exe?

I haven't a clue how to do this ... any advice/example would be greatly
appreciated.

Thanks!