TableSelect::limit

(No version information available, might only be in Git)

TableSelect::limit — Limit selected rows

说明

public mysql_xdevapi\TableSelect::limit ( integer $rows ) : mysql_xdevapi\TableSelect

Sets the maximum number of records or documents to return.

参数

rows: The maximum number of records or documents.

返回值

A TableSelect object.

范例

Example #1 mysql_xdevapi\TableSelect::limit() example

 <?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");

$schema = $session->getSchema("addressbook");
$table  = $schema->getTable("names");

$result = $table->select('name', 'age')
  ->limit(1)
  ->execute();

$row = $result->fetchAll();
print_r($row);
?>

以上例程的输出类似于：

Array
(
    [0] => Array
        (
            [name] => John
            [age] => 42
        )
)

相关文章

php mysql xdevapi tableselect class php mysql xdevapi collectionfind limit number of returned documents php mysql xdevapi collectionremove limit number of documents to remove php mysql xdevapi crudoperationlimitable set result limit php mysql xdevapi sqlstatementresult get all rows from result php mysql xdevapi table insert table rows php mysql xdevapi table select rows from table php mysql xdevapi table update rows in table php mysql xdevapi tabledelete limit deleted rows php mysql xdevapi tabledelete set delete limit offset php mysql xdevapi tableselect tableselect constructor php mysql xdevapi tableselect execute select statement php mysql xdevapi tableselect set select grouping criteria php mysql xdevapi tableselect set select having condition php mysql xdevapi tableselect limit selected rows php mysql xdevapi tableselect execute exclusive lock php mysql xdevapi tableselect execute shared lock php mysql xdevapi tableselect set limit offset php mysql xdevapi tableselect set select sort criteria php mysql xdevapi tableselect set select search condition

关注编程学问公众号