CODEWITHSUNDEEP
mysqlstored-proceduresinvoke
Louise Lee
Louise Lee

Reputation: 1

How to call stored procedure in mysql?

A stored procedure was created in mysql successfully but was not able to be executed in mysql.

How to invoke stored procedure in mysql?

Upvotes: 0

Views: 202

Answers (1)

BK435
BK435

Reputation: 3176

The Stored Procedure is just that, a Stored Procedure. When you run it, all you are doing is creating the Stored Procedure.

To execute the Stored Procedure you actually have to call the Stored Procedure with it's respective in and out parameters. Out parameters (op) should be preceded by an @ symbol.

Call SP_name(p1,p1,@op1,@op2);

When in doubt just go to dev.mysql

Upvotes: 2

Related Questions