views:

13

answers:

0

I want to create a batch file that I can run from the desktop. This batch file should execute a stored procedure in mysql.

This is what i have so far, the batch file logs into the server but it doesnt execute the stored procedure

<---- start: run_stored_proc.bat ----->

cd\ cd Program Files cd mysql cd mysql server 5.1 cd bin mysql.exe -h host_ip -u login --password=password mysql use database_name \g mysql call sp_stored_proc_name \g

<---- end ----->