Browsing All Posts published on »November, 2011«

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

November 15, 2011


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 […]