讓shell script執行MySQL指令

> vi　/var/db/process.sh

#呼叫MySQL StoreProcedure

#!/bin/sh
/usr/local/bin/mysql -uroot -prootpass -vvv -e "CALL TESTDB.pr_process_list()" > out.txt

-vvv : 可將訊息輸出到out.txt

或
usr/local/bin/mysql -uroot -prootpass -vvv < mysqlinputdata.txt > mysqloutputdata.txt
mysql執行mysqlinputdata.txt檔，並將訊息輸出到mysqloutputdata.txt