The mysql query statement USES limit to limit the number of rows in the query

mysql query statement, using limit to limit the number of rows in the query.

Such as:

select name from usertb where age > 20 limit 0, 1; // Limit starts with item 1 and displays item 1

select name from usertb where age > 20 limit 1; // Same as above

select name from usertb where age > 20 limit 4, 1; // Display 1 item starting with item 5