Execute MySQL script with shell script

#!/bin/bashhostname= "127.0.0.1"        #数据库本机地址PORT = "3306" username= "root" password= "pwd" dbname= "Tbs_ra_data" Execsql= "Call Delete_flow_onebyone ()"  //here can be an SQL statement or invoke a stored procedure echo  "Begin  execute MYSQL  SQL ... "Mysql-h${hostname}   -p${port}   -u${username}-p${password} ${dbname}-E" ${execsql} "Echo  " End Execute  MYSQL  SQL ....... ... "."

If you need to hang a script in the background, the background of the execution of MySQL stored procedures or statements, can be executed in the script background, directly hang, terminal can be exited.

Execute MySQL script with shell script