<?php /** * `UPDATE` statement. */ namespace SqlParser\Statements; use SqlParser\Statement; use SqlParser\Components\Expression; use SqlParser\Components\Limit; use SqlParser\Components\OrderKeyword; use SqlParser\Components\SetOperation; use SqlParser\Components\Condition; /** * `UPDATE` statement. * * UPDATE [LOW_PRIORITY] [IGNORE] table_reference * SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ... * [WHERE where_condition] * [ORDER BY ...] * [LIMIT row_count] * * or * * UPDATE [LOW_PRIORITY] [IGNORE] table_references * SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ... * [WHERE where_condition] * * @category Statements * * @license https://www.gnu.org/licenses/gpl-2.0.txt GPL-2.0+ */ class UpdateStatement extends Statement { /** * Options for `UPDATE` statements and their slot ID. * * @var array */ public static $OPTIONS = array( 'LOW_PRIORITY' => 1, 'IGNORE' => 2, ); /** * The clauses of this statement, in order. * * @see Statement::$CLAUSES * * @var array */ public static $CLAUSES = array( 'UPDATE' => array('UPDATE', 2), // Used for options. '_OPTIONS' => array('_OPTIONS', 1), // Used for updated tables. '_UPDATE' => array('UPDATE', 1), 'SET' => array('SET', 3), 'WHERE' => array('WHERE', 3), 'ORDER BY' => array('ORDER BY', 3), 'LIMIT' => array('LIMIT', 3), ); /** * Tables used as sources for this statement. * * @var Expression[] */ public $tables; /** * The updated values. * * @var SetOperation[] */ public $set; /** * Conditions used for filtering each row of the result set. * * @var Condition[] */ public $where; /** * Specifies the order of the rows in the result set. * * @var OrderKeyword[] */ public $order; /** * Conditions used for limiting the size of the result set. * * @var Limit */ public $limit; }
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
AlterStatement.php | File | 3.67 KB | 0644 |
|
AnalyzeStatement.php | File | 680 B | 0644 |
|
BackupStatement.php | File | 563 B | 0644 |
|
CallStatement.php | File | 491 B | 0644 |
|
CheckStatement.php | File | 593 B | 0644 |
|
ChecksumStatement.php | File | 517 B | 0644 |
|
CreateStatement.php | File | 19.84 KB | 0644 |
|
DeleteStatement.php | File | 10.59 KB | 0644 |
|
DropStatement.php | File | 1.33 KB | 0644 |
|
ExplainStatement.php | File | 261 B | 0644 |
|
InsertStatement.php | File | 7.18 KB | 0644 |
|
MaintenanceStatement.php | File | 1.46 KB | 0644 |
|
NotImplementedStatement.php | File | 1.36 KB | 0644 |
|
OptimizeStatement.php | File | 685 B | 0644 |
|
RenameStatement.php | File | 1.2 KB | 0644 |
|
RepairStatement.php | File | 636 B | 0644 |
|
ReplaceStatement.php | File | 5.2 KB | 0644 |
|
RestoreStatement.php | File | 513 B | 0644 |
|
SelectStatement.php | File | 6.23 KB | 0644 |
|
SetStatement.php | File | 1.21 KB | 0644 |
|
ShowStatement.php | File | 1.31 KB | 0644 |
|
TransactionStatement.php | File | 2.35 KB | 0644 |
|
TruncateStatement.php | File | 567 B | 0644 |
|
UpdateStatement.php | File | 2.11 KB | 0644 |
|