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 classphp mysql xdevapi collectionmodify limit number of modified documentsphp mysql xdevapi collectionremove limit number of documents to removephp mysql xdevapi crudoperationlimitable set result limitphp mysql xdevapi docresult get all rowsphp mysql xdevapi rowresult get all rows from resultphp mysql xdevapi sqlstatementresult get all rows from resultphp mysql xdevapi table delete rows from tablephp mysql xdevapi table select rows from tablephp mysql xdevapi table update rows in tablephp mysql xdevapi tabledelete limit deleted rowsphp mysql xdevapi tabledelete set delete limit offsetphp mysql xdevapi tableselect set select having conditionphp mysql xdevapi tableselect limit selected rowsphp mysql xdevapi tableselect execute exclusive lockphp mysql xdevapi tableselect execute shared lockphp mysql xdevapi tableselect set limit offsetphp mysql xdevapi tableselect set select sort criteriaphp mysql xdevapi tableselect set select search conditionphp mysql xdevapi tableupdate limit update row count
关注编程学问公众号