MYSQL存储过程实例

//MYSQL存储过程//实例一DELIMITER $$CREATE PROCEDURE userName ()     BEGINSELECT `name` FROM `zz_user`;     END$$DELIMITER ;CALL userName ();  //实例二DELIMITER $$CREATE PROCEDURE getUser(page_begin INT , page_end INT)     BEGINPREPARE ss FROM 'SELECT `name` FROM `zz_user` WHERE 1=1 LIMIT ?,?'; SET @a=page_begin;SET @b=page_end;EXECUTE ss USING @a,@b;DEALLOCATE PREPARE ss;    END$$DELIMITER ;SET @a = 1;SET @b = 5;CALL getUser(@a , @b);