How to create and execute stored procedure in linux mysql command? [ Linux Mysql: Create and execute stored procedures ]
Sql Scripts for creating stored procedures:
mysql > delimiters //
mysql > use userDB;
> select database();
> create procedure userdbprdt()
> begin
> select u.id,u.name,u.username,ur.product from usertbl u join userproduct ur where u.id=ur.id; > end//
Sql script for executing stored procedure
mysql> call userdbprdt()//
mysql > delimiters //
mysql > use userDB;
> select database();
> create procedure userdbprdt()
> begin
> select u.id,u.name,u.username,ur.product from usertbl u join userproduct ur where u.id=ur.id; > end//
Sql script for executing stored procedure
mysql> call userdbprdt()//
Comments
Post a Comment
Share this to your friends