MySQL的分页查询语句limit

假设,一个表中有一百条数据,我要查询第5页,每页10条数据,SQL语句怎么写?是用limit么?
不用涉及到Java语言,就SQL语句

SELECT * FROM tablename LIMIT 5,10

SELECT * FROM table LIMIT 51,10;

查询第m页,每页n条数据
SELECT * FROM tablename LIMIT (m-1)*n,n

SELECT * FROM tablename LIMIT 5,10