select first 10 rows mysql code example Example: how to get first 10 records of a table in mysql SELECT *FROM yourTableName ORDER BY yourIdColumnName LIMIT 10;