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
Copyright: © 2005-2021 ООО "Хостмэйк" (Hostmake LLC), http://www.hostcms.ru
Author: Hostmake LLC
Version: 6.x
Located at core/querybuilder/update.php
Methods summary
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
protected
string
|
|
public
string
|
|
public
|
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 |
#
array()
|
protected
array
|
$_columns
List of columns |
#
array()
|
protected
mixed
|
$_priority
LOW_PRIORITY |
#
NULL
|
protected
mixed
|
$_ignore
IGNORE |
#
NULL
|
protected
integer
|
$_queryType
DataBase Query Type 2 - UPDATE |
#
2
|
Properties inherited from Core_QueryBuilder_Selection
$_defaultOperator
,
$_indexHints
,
$_join
,
$_limit
,
$_offset
,
$_operator
,
$_orderBy
,
$_partition
,
$_where