if i use LIMIT on a mysql query, should the result set be equal to the limit? -

For example, select * range from 0,5
return to maximum 5 rows Or
it should be got exactly 5 and if the count of the line does not equal 5, does it give a blank result set?

What if the query selects> 5 from the table limit?

query SELECT * will return table LIMIT 0,5 from first record 5 records starting

The query will also give the same result as above of the SELECT * FROM TABLE LIMIT 5 .

If there are fewer than 5 records in that table, it will not fail, but return any records that are recorded.

query SELECT * FROM TABLE LIMIT 6,5 records 7,8,9, 10,11 as index starts with 0.