Class Core_QueryBuilder_Delete
DELETE Database Abstraction Layer (DBAL)
http://dev.mysql.com/doc/refman/5.5/en/delete.html
// DELETE FROM `tableName` WHERE `column1` = '17' $delete = Core_QueryBuilder::delete('tableName') ->where('column1', '=', '17') ->execute();
// DELETE LOW_PRIORITY QUICK IGNORE FROM `tableName` // WHERE `column1` = '17' AND `column2` != '19' // ORDER BY `field1` DESC LIMIT 10 $delete = Core_QueryBuilder::delete('tableName') ->lowPriority() ->quick() ->ignore() ->where('column1', '=', '17') ->where('column2', '!=', '19') ->orderBy('field1', 'DESC') ->limit(10) ->execute();
- Core_QueryBuilder_Statement
- Core_QueryBuilder_Selection
- Core_QueryBuilder_Delete
Copyright: © 2005-2021 ООО "Хостмэйк" (Hostmake LLC), http://www.hostcms.ru
Author: Hostmake LLC
Version: 6.x
Located at core/querybuilder/delete.php
Methods summary
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
string
|
Methods inherited from Core_QueryBuilder_Selection
_buildExpression()
,
_buildIndexHint()
,
_buildJoin()
,
_buildOrderBy()
,
_buildWhere()
,
_join()
,
_quoteTables()
,
asAssoc()
,
asObject()
,
clear()
,
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
Columns |
#
array()
|
protected
mixed
|
$_priority
Use LOW_PRIORITY |
#
NULL
|
protected
mixed
|
$_quick
Use QUICK |
#
NULL
|
protected
mixed
|
$_ignore
Use IGNORE |
#
NULL
|
protected
integer
|
$_queryType
DataBase Query Type 3 - DELETE |
#
3
|
Properties inherited from Core_QueryBuilder_Selection
$_defaultOperator
,
$_indexHints
,
$_join
,
$_limit
,
$_offset
,
$_operator
,
$_orderBy
,
$_partition
,
$_where