출처1 : <a href="http://www.mysqlkorea.com/sub.html?mcode=develop&amp;scode=01&amp;lang=k&amp;m_no=21838&amp;cat1=12&amp;cat2=359&amp;cat3=374" target="_blank" class="tx-link">http://www.mysqlkorea.com/sub.html?mcode=develop&amp;scode=01&amp;lang=k&amp;m_no=21838&amp;cat1=12&amp;cat2=359&amp;cat3=374</a>출처2 :&nbsp;<a href="https://blog.naver.com/hschoi82/20050239561" target="_blank" class="tx-link">https://blog.naver.com/hschoi82/20050239561</a> <a href="http://motolies.tistory.com/697" target="_blank">2018/07/24 - [프로그램 자료/MySQL &amp; MariaDB] - [MySQL &amp; MariaDB] 동적 프로시저 dynamic procedure</a> SQL_CALC_FOUND_ROWS 키워드와 FOUND_ROWS() 함수를 이용하여 Limit를 제외한 Select 문장의 전체 로우 수를 캐쉬에 저장하는 방법이다.MYSQL 매뉴얼에선 일반적인 방법으로 조회를 2번 하는것보다빠르다고 한다.실제로 테스트 해보면 캐쉬 사용 문제로 더 느릴수도 있다고 한다.<div> </div> 기본 베이스는 아래와 같다. <div class="txc-textbox" style="border-style: solid; border-width: 1px; border-color: rgb(254, 254, 184); background-color: rgb(254, 254, 184); padding: 10px;">SELECT SQL_CALC_FOUND_ROWS *FROM&nbsp;&nbsp; tabaleNameLIMIT&nbsp; 0, 10;&nbsp;







SELECT FOUND_ROWS();</div> 다음은 동적쿼리로 사용시 샘플이다. <div class="txc-textbox" style="border-style: solid; border-width: 1px; border-color: rgb(254, 254, 184); background-color: rgb(254, 254, 184); padding: 10px;"> DELIMITER $$

&nbsp;

USE `demoDB`$$

&nbsp;

&nbsp;&nbsp;&nbsp; DROP PROCEDURE
IF EXISTS
proc_name$

&nbsp;&nbsp;&nbsp; 

&nbsp;&nbsp;&nbsp; CREATE DEFINER='userId'@'%' PROCEDURE proc_name

&nbsp;&nbsp;&nbsp; (

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; in pOffset int, 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; in pSize int, 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out totalCount int

&nbsp;&nbsp;&nbsp; )

&nbsp;&nbsp;&nbsp; LANGUAGE SQL

&nbsp;&nbsp;&nbsp; NOT DETERMINISTIC

&nbsp;&nbsp;&nbsp; CONTAINS SQL

&nbsp;&nbsp;&nbsp; SQL SECURITY DEFINER

&nbsp;&nbsp;&nbsp; COMMENT '테스트 프로시저'

&nbsp;&nbsp;&nbsp; BEGIN

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET @pOffset :=
IFNULL(pOffset, 0);

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET @pSize :=
IFNULL(pSize, 10);

&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET @Sql = "";

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET @Sql = CONCAT(@Sql, CHAR(10),"select
SQL_CALC_FOUND_ROWS * ");

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET @Sql = CONCAT(@Sql, CHAR(10),"from
tableName");

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET @Sql = CONCAT(@Sql, CHAR(10),"limit ?,?");

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #select @Sql;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PREPARE dquery FROM
@Sql;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXECUTE dquery USING
@pOffset, @pSize;

&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET totalCount :=
FOUND_ROWS();

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 

&nbsp;&nbsp;&nbsp; END$$

DELIMITER ;</div>

[MySQL & MariaDB] 페이지네이션 / 페이징 처리 pagination, paging 쿼리