How to select top 10 rows from a table

mysql> SELECT * FROM table_name LIMIT 10;
SELECT * FROM tbl LIMIT 5,10 gives 10 rows starting from row #5