Google+ Followers

Connect

Get Updates Via Email

Enter your email address:

Delivered by FeedBurner

Saturday, 16 November 2013

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

1 comment :

  1. I have read your blog its very attractive and impressive. I like it your blog.

    Java Online Training Java EE Online Training Java EE Online Training Java 8 online training Core Java 8 online training

    Java Online Training from India Java Online Training from India Core Java Training Online Core Java Training Online Java Training InstitutesJava Training Institutes

    ReplyDelete

Share this to your friends