mysql - get records from table starting from row 5 onwards -


i have mysql database , want records starting row 5 onwards. sing right

select * categories status = 1  limit 5 18446744073709551615 order sortorder asc 

but throwing me error

error executing database query.

you have error in sql syntax; check manual corresponds mysql server version right syntax use near '18446744073709551615    order    sortorder ' @ line 6 

also not sure @ point if correct way of doing or not

thanks

you require offset

example:

select table limit $limit offset $offset;  //or alternatively select table limit $offset,$limit; 

regarding error:

remove number - in first place?

your statement should be:

select * categories status = 1  offset 5 order sortorder asc 

Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -