목록Programming/DB (2)
알이즈웰
[MySql] SQL_CALC_FOUND_ROWS, FOUND_ROWS()
*SQL_CALC_FOUND_ROWS를 사용하고, FOUND_ROWS() 쓸때의 주의점 1.SELECT SQL_CALC_FOUND_ROWS a.column1 a.column2FROM (SELECT column1, column2 FROM table order by reg_date desc) aLEFT JOIN table b on a.column1 = b.column1limit 0,500 2.SELECT SQL_CALC_FOUND_ROWS a.column1 a.column2FROM (SELECT column1, column2 FROM table order by reg_date desc limit 0,500) aLEFT JOIN table b on a.column1 = b.column1 1, 2번의 차이는 l..
Programming/DB
2018. 11. 28. 11:10