//MYSQL存储过程
//实例一
DELIMITER $$
CREATE PROCEDURE userName ()
BEGIN
SELECT `name` FROM `zz_user`;
END$$
DELIMITER ;
CALL userName ();
//实例二
DELIMITER $$
CREATE PROCEDURE getUser(page_begin INT , page_end INT)
BEGIN
PREPARE 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);
MYSQL存储过程实例
最新推荐文章于 2023-10-12 13:55:36 发布