Execute MySQL Stored Procedure using Command Line

mysql database stored-procedures command-line

$ mysql --user=user_name --password=your_password db_namemysql> call stored_procedure_name();

$ mysql --user=user_name --password=your_password db_name < script.sql

where script.sql contains your sql statement:

call stored_procedure_name();

mysql database stored-procedures command-line

Or:

mysql --user=your_username --execute="call stored_procedure_name()" db_name

The same as:

mysql ...  -e "call stored_procedure_name()" ...

mysql database stored-procedures command-line

Or if you don't want to create a .sql file:

$ mysql -u your_username --password=your_password db_name <<!!call stored_procedure_name();!!

CodeHunter