Table::update

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

Table::update — Update rows in table

说明

public mysql_xdevapi\Table::update ( void ) : mysql_xdevapi\TableUpdate

Updates columns in a table.

参数

此函数没有参数。

返回值

A TableUpdate object; use the execute() method to execute the update statement.

范例

Example #1 mysql_xdevapi\Table::update() 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->update()->set('age',34)->where('name = "Sam"')->limit(1)->execute();
?>
相关文章
php mysql xdevapi columnresult get table labelphp mysql xdevapi docresult get all rowsphp mysql xdevapi rowresult get all rows from resultphp mysql xdevapi schema get collection table objectphp mysql xdevapi schema get schema tablephp mysql xdevapi sqlstatementresult get all rows from resultphp mysql xdevapi table table constructorphp mysql xdevapi table get row countphp mysql xdevapi table delete rows from tablephp mysql xdevapi table check if table exists in databasephp mysql xdevapi table get table namephp mysql xdevapi table get table schemaphp mysql xdevapi table get table sessionphp mysql xdevapi table insert table rowsphp mysql xdevapi table select rows from tablephp mysql xdevapi table update rows in tablephp mysql xdevapi tabledelete limit deleted rowsphp mysql xdevapi tableupdate bind update query parametersphp mysql xdevapi tableupdate execute update queryphp mysql xdevapi tableupdate limit update row count
关注编程学问公众号