mysql 로 간단한 게시판 리스트 프로시저 만들기
Posted by Albert 4113Day 7Hour 26Min 24Sec ago [2014-01-16]
DELIMITER $$
USE `ipang`$$
DROP PROCEDURE IF EXISTS `bbs_list`$$
CREATE DEFINER=`ipang`@`%` PROCEDURE `bbs_list`(
IN startnum INT,
IN limitnum INT,
OUT cnt INT
)
BEGIN
SET @skip=startnum;
SET @lastnum=limitnum;
SELECT COUNT(*) INTO cnt FROM enews;
PREPARE stmt FROM 'SELECT * FROM enews WHERE 1 ORDER BY regdate DESC LIMIT ?, ?';
EXECUTE stmt USING @skip,@lastnum;
END$$
DELIMITER ;
민달고 사용시에는
CALL bbs_list(0,5,@out_vl)
SELECT @out_vl