create stored procedure in mysql

mysql_stored

# set the delimiter to // to avoid confusion with the ; in the procedure body 
delimiter //

 CREATE PROCEDURE  people()
 BEGIN
 SELECT user, host, password from mysql.user ;
 END //


# To see the procedures 

SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES;
 

# To call the procedure 

call people () ;


 CREATE PROCEDURE  procedures() BEGIN  SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES; END //


# I use this to find the DN associated with a login_name  
CREATE PROCEDURE find_common() 
BEGIN  SELECT enterprise.DN from enterprise, users where enterprise.entr_id = users.entr_id and users.login_name=login_name ;  END //