Shell script calls mysql stored procedure _ MySQL

The shell script calls the mysql stored procedure bitsCN.com

#! /Bin/sh # The function of the script is used to balance statistics, we get # data from the table accseqs, after the analysis and calculation data, # the results will be inserted into the table acc_balances. # the script is executed at 1 o 'clock by every day. DIR = "/var/www/apps/SQL" DATE = $ (date + % Y % m % d -- date '1 days ago '?host=192.168.=95user=adminpasswd=00database=zhxtfile=result.txt cd $ {DIR} echo "the date: "$ {DATE} SQL =" exec mysql-h $ {HOST}-u $ {USER}-p $ {PASSWD}-D $ {DATABASE} -- default-character-set = utf8-e/"call query_balance ($ {DATE }) /"" echo $ {SQL }>$ {FILE} if mysql-h $ {HOST}/-u $ {USER}/-p $ {PASSWD}/-D $ {DATABASE}/-- default-character-set = utf8/-e "call query_balance ($ {DATE }) "; then echo" OK ">$ {FILE} else echo" fail ">>> {FILE} fiexit

BitsCN.com