Search code examples
mysqlselectlimit

MySQL Limit Offset Difference

I am just trying to understand difference in MySQL's LIMIT syntax.

What is the difference between:

LIMIT 0, 30

vs.

LIMIT 30

in a select statement?

Solution

  • There is no difference.

    If you leave the offset parameter, it will be 0 by default.