CODEWITHSUNDEEP
mysqldatabasestored-procedurescommand-line
Maxymus
Maxymus

Reputation: 1480

Execute MySQL Stored Procedure using Command Line

Please help me out to execute a MySQL Stored procedure in command line, where the procedure contains conditional statements..

Upvotes: 20

Views: 82694

Answers (5)

Johnn Gutierrez
Johnn Gutierrez

Reputation: 1

mysql.exe --user=root --password= --host=localhost --port=3306 --database=mydatabase -e "CALL miprocedure('2','1')"'

Upvotes: 0

biniam
biniam

Reputation: 8199

If you have parameters,

call stored_procedure_name(intValue, doubleValue, 'dateValue');

If your stored procedure doesnot take parameters,

call stored_procedure_name();

Upvotes: 4

Mikhail
Mikhail

Reputation: 331

Or:

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

The same as:

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

Upvotes: 22

Andy Mc
Andy Mc

Reputation: 388

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

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

Upvotes: 6

dogbane
dogbane

Reputation: 274640

$ mysql --user=user_name --password=your_password db_name

mysql> call stored_procedure_name();

or

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

where script.sql contains your sql statement:

call stored_procedure_name();

Upvotes: 42

Related Questions