search

iknowahra / cspiEdu

CSPI OJT
0 stars 0 forks source link

sql paging_mariadb #41

Open iknowahra opened 2 years ago

iknowahra commented 2 years ago 
<![CDATA[
    SELECT
         NO, title, content, writer, reg_dt AS regDt 
    FROM tbl_practice
    Having no < #{pageNum}
    ORDER BY no DESC
    LIMIT #{amount}
    ]]>
iknowahra commented 2 years ago

heidi로 실험하실땐 cdata 이부분은 빼주세요

iknowahra commented 2 years ago

limit와 offset으로 연동해서 만드는 방법 있다고 하는데.. 찾아보아요

choi-hyeongseok commented 2 years ago

감사합니다..! 참고하도록 하겠습니다...!