QuickTip: Limiting the number of rows returned by MySQL. Pagination

If you would like to get a row num, you would have to do something like this for getting it in the right order or simply For limiting the number of rows however, there is the LIMIT keyword [bash] mysql> select * from CODE_PANEL_DETAIL limit 1,4; +———————-+—————+——+—————————–+——————–+ | CODE_PANEL_DETAIL_ID | CODE_PANEL_ID | CODE | CODE_TYPE […]