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()//