How to enable and execute stored procedures in mysql
Incase you want to execute a stored procedure , you will face problems like root access needed.
To over come that problem we need to run a query to grant access to execute a stored procedure in mysql.
Following is the query.
grant all on *.* to ‘root’@’%’ identified by ‘password’ with grant option;
To execute a Stored procedure in mysql , we need to use CALL function like follows.
Suppose the name of the stored procedure is get_emp_name ,then to run this procedure
just write the following query
To execute a parameter based stored procudure ,you can write following query like follows.