MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
CrudOperationLimitable::limit
Set result limit
abstract public mysql_xdevapi\CrudOperationLimitable mysql_xdevapi\CrudOperationLimitable::limit(int rows);
Sets the maximum number of records or documents to return.
This function is currently not documented; only its argument list is available.
rows
The maximum number of records or documents.
A CrudOperationLimitable object.
Example 5.71 mysql_xdevapi\CrudOperationLimitable::limit
example
<?php $res = $coll->find()->fields(['name as n','age as a','job as j'])->groupBy('j')->limit(11)->execute(); $res = $table->update()->set('age',69)->where('age > 15 and age < 22')->limit(4)->orderby(['age asc','name desc'])->execute(); ?>