How to Execute Query & Stored Procedure in Linux Using Shell Scripting.
You can simply use below mention script for executing the query or procedure.
mysql -u root –ppassword -e 'call test_procedure();' Databasename
Where -p is used password in which you can mention the password of your mysql.
Where -e is used for executing the query or stored procedure.
Where databasename is used for your mysql database name.
mysql -u root –ppassword -e ‘select * from tbl_test;’ Databasename
This single line can be used for executing stored procedure as well as sql query.
You can save this script into any extension of file but you need to give the permission first
for executing the script file
#chmod +x filename