PHP 8.1.28 Released!

TableDelete::limit

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

TableDelete::limitLimit deleted rows

Description

public mysql_xdevapi\TableDelete::limit(int $rows): mysql_xdevapi\TableDelete

Sets the maximum number of records or documents to delete.

Liste de paramètres

rows

The maximum number of records or documents to delete.

Valeurs de retour

TableDelete object.

Exemples

Exemple #1 mysql_xdevapi\TableDelete::limit() example

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

$session->sql("DROP DATABASE IF EXISTS addressbook")->execute();
$session->sql("CREATE DATABASE addressbook")->execute();
$session->sql("CREATE TABLE addressbook.names(name text, age int)")->execute();
$session->sql("INSERT INTO addressbook.names values ('John', 42), ('Sam', 33)")->execute();

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

$table->delete()
->
where("name = :name")
->
bind(['name' => 'John'])
->
orderby("age DESC")
->
limit(1)
->
execute();

?>
add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top