How can i reduce the amount of table rows returned

Post Reply
User avatar
Administrator
Site Admin
Posts: 1752
Joined: Thu Mar 22, 2018 10:19 am

How can i reduce the amount of table rows returned

Post by Administrator » Tue Jan 01, 2019 5:37 am

You can reduce the amount of data returned from a database query by using LIMIT

Code: Select all

SELECT * FROM `table_name`
LIMIT 1
you can also supply a OFFSET for a pagination like effect

Post Reply