Class Core_QueryBuilder_Update

UPDATE Database Abstraction Layer (DBAL)

http://dev.mysql.com/doc/refman/5.5/en/update.html

// UPDATE `tableName` SET `column1` = 'value', `column2` = 'value2'
// WHERE `column` != '5' AND `a4` IN (17, 19, NULL) ORDER BY `column2` ASC LIMIT 10
$update = Core_QueryBuilder::update('tableName')
    ->columns(array('column1' => 'value', 'column2' => 'value2'))
    ->where('column', '!=', '5')
    ->where('a4', 'IN', array(17,19, NULL))
    ->orderBy('column2')
    ->limit(10)
    ->execute();

// UPDATE `tableName` SET `column1` = 'value', `column2` = 'value2' WHERE `column` = '5'
$oCore_QueryBuilder_Update = Core_QueryBuilder::update('tableName')
     ->set('column1', 'value')
     ->set('column2', 'value2')
    ->where('column', '=', '5')
    ->execute();

Core_QueryBuilder_Statement

Core_QueryBuilder_Selection

Core_QueryBuilder_Update

Package: HostCMS\Core\Querybuilder
Copyright: © 2005-2021 ООО "Хостмэйк" (Hostmake LLC), http://www.hostcms.ru
Author: Hostmake LLC
Version: 6.x
Located at core/querybuilder/update.php

Methods summary

`public`	# `__construct( array $args = array() )` Constructor. Constructor. Parameters `$args` list of arguments $oCore_QueryBuilder_Update = Core_QueryBuilder::update('tableName'); $oCore_QueryBuilder_Update = Core_QueryBuilder::update('tableName', array('tableName2', 'aliasTable2')); See `Core_QueryBuilder_Update::table()` Overrides `Core_QueryBuilder_Selection::__construct`
`public Core_QueryBuilder_Update`	# `lowPriority( )` Set LOW_PRIORITY Set LOW_PRIORITY $oCore_QueryBuilder_Update = Core_QueryBuilder::update('tableName')->lowPriority(); Returns `Core_QueryBuilder_Update`
`public Core_QueryBuilder_Update`	# `ignore( )` Set IGNORE Set IGNORE $oCore_QueryBuilder_Update = Core_QueryBuilder::update('tableName')->ignore(); Returns `Core_QueryBuilder_Update`
`public Core_QueryBuilder_Update`	# `table( )` Add table name Add table name // UPDATE `tableName` $oCore_QueryBuilder_Update = Core_QueryBuilder::update()->table('tableName'); Returns `Core_QueryBuilder_Update`
`public Core_QueryBuilder_Update`	# `columns( array $args )` Add multiple columns for UPDATE Add multiple columns for UPDATE // UPDATE `tableName` SET `column` = 'value', `column2` = 'value3' $oCore_QueryBuilder_Update = Core_QueryBuilder::update('tableName') ->columns(array('column' => 'value', 'column2' => 'value3')); Parameters `$args` array of columns Returns `Core_QueryBuilder_Update`
`public Core_QueryBuilder_Update`	# `set( string $column, string $value )` Add column for UPDATE Add column for UPDATE // UPDATE `tableName` SET `column` = 'value' $oCore_QueryBuilder_Update = Core_QueryBuilder::update('tableName') ->set('column', 'value'); Parameters `$column` column name `$value` column value Returns `Core_QueryBuilder_Update`
`protected string`	# `_buildSet( array $columns )` Build SET expression Build SET expression Parameters `$columns` columns list Returns string The SQL query
`public string`	# `build( )` Build the SQL query Build the SQL query Returns string The SQL query
`public Core_QueryBuilder_Update`	# `clear( )` Clear Clear Returns `Core_QueryBuilder_Update` Overrides `Core_QueryBuilder_Selection::clear`

Methods inherited from Core_QueryBuilder_Selection

_buildExpression(), _buildIndexHint(), _buildJoin(), _buildOrderBy(), _buildWhere(), _join(), _quoteTables(), asAssoc(), asObject(), clearIndexHints(), clearJoin(), clearOrderBy(), clearWhere(), close(), crossJoin(), deleteFirstWhere(), deleteLastWhere(), firstJoin(), firstLeftJoin(), getJoin(), getOrderBy(), getWhere(), indexHint(), join(), leftJoin(), limit(), naturalJoin(), offset(), open(), orWhere(), orWhereBetween(), orWhereColumn(), orWhereIn(), orWhereIsNotNull(), orWhereIsNull(), orWhereNotBetween(), orWhereNotIn(), order(), orderBy(), orderByRaw(), partition(), quoteTable(), rightJoin(), rightJoinFirst(), setAnd(), setDefaultOperator(), setOperator(), setOr(), where(), whereBetween(), whereColumn(), whereIn(), whereIsNotNull(), whereIsNull(), whereNotBetween(), whereNotIn(), whereRaw()

Methods inherited from Core_QueryBuilder_Statement

__call(), __set(), _isObjectSelect(), _quoteColumns(), _quoteValues(), clearLimit(), clearOffset(), execute(), setDataBase(), unbuffered()

Properties summary

`protected string`	`$_tableName` Name of the table Name of the table	# `array()`
`protected array`	`$_columns` List of columns List of columns	# `array()`
`protected mixed`	`$_priority` LOW_PRIORITY LOW_PRIORITY	# `NULL`
`protected mixed`	`$_ignore` IGNORE IGNORE	# `NULL`
`protected integer`	`$_queryType` DataBase Query Type 2 - UPDATE DataBase Query Type 2 - UPDATE	# `2`

Properties inherited from Core_QueryBuilder_Selection

$_defaultOperator, $_indexHints, $_join, $_limit, $_offset, $_operator, $_orderBy, $_partition, $_where

Properties inherited from Core_QueryBuilder_Statement

$_dataBase, $_unbuffered

Classes

Exceptions

Functions

Class Core_QueryBuilder_Update

Methods summary

Parameters

See

Overrides

Returns

Returns

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Returns

Returns

Overrides

Methods inherited from Core_QueryBuilder_Selection

Methods inherited from Core_QueryBuilder_Statement

Properties summary

Properties inherited from Core_QueryBuilder_Selection

Properties inherited from Core_QueryBuilder_Statement