Limit the resultset in MySQL

You can limit the resultset of the database query by adding :


///**********************************************************
limit index, length
///**********************************************************

for example: select * from tblCustomers limit 0,10;
which shows the out put from the database only first 10 customers from 0 rows.