Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2018/05/22(11:23) from 211.209.26.174 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 2307 , ÁÙ¼ö : 18 |
Re: [MySQL] ÆäÀÌ¡½Ã ·¹ÄÚµå ÃÑ °¹¼ö ÇÔ²² ±¸Çϱâ |
---|
@ SQL_CALC_FOUND_ROWS & FOUND_ROWS() <select id="selectAllBook" parameterType="hashmap" resultMap="resultBook"> SELECT SQL_CALC_FOUND_ROWS book_code, book_name, book_author, book_made, book_price, book_lending_possible FROM book LIMIT #{offset}, #{noOfRecords} </select> <select id="selectTotalRecords" resultType="int"> SELECT FOUND_ROWS(); </select> |