TableDelete::limit

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

    TableDelete::limit — Limit deleted rows

    Description

    publicmysql_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();

    ?>
    To Top