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

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

Methods summary

`public`	# `__construct( array $args = array() )` Constructor. Constructor. Parameters `$args` list of arguments $oCore_QueryBuilder_Delete = Core_QueryBuilder::delete('tableName'); $oCore_QueryBuilder_Delete = Core_QueryBuilder::delete('tableName', array('tableName2', 'aliasTable2')); See `Core_QueryBuilder_Delete::table()` Overrides `Core_QueryBuilder_Selection::__construct`
`public Core_QueryBuilder_Delete`	# `lowPriority( )` Set LOW_PRIORITY Set LOW_PRIORITY $oCore_QueryBuilder_Delete = Core_QueryBuilder::delete('tableName')->lowPriority(); Returns `Core_QueryBuilder_Delete`
`public Core_QueryBuilder_Delete`	# `quick( )` Set QUICK Set QUICK $oCore_QueryBuilder_Delete = Core_QueryBuilder::delete('tableName')->quick(); Returns `Core_QueryBuilder_Delete`
`public Core_QueryBuilder_Delete`	# `ignore( )` Set IGNORE Set IGNORE $oCore_QueryBuilder_Delete = Core_QueryBuilder::delete('tableName')->ignore(); Returns `Core_QueryBuilder_Delete`
`public Core_QueryBuilder_Delete`	# `table( )` Add table name Add table name // DELETE FROM `tableName` $oCore_QueryBuilder_Delete = Core_QueryBuilder::delete()->table('tableName'); Returns `Core_QueryBuilder_Delete`
`public string`	# `build( )` Build the SQL query Build the SQL query Returns string The SQL query

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 Name of the table	# `array()`
`protected array`	`$_columns` Columns Columns	# `array()`
`protected mixed`	`$_priority` Use LOW_PRIORITY Use LOW_PRIORITY	# `NULL`
`protected mixed`	`$_quick` Use QUICK Use QUICK	# `NULL`
`protected mixed`	`$_ignore` Use IGNORE Use IGNORE	# `NULL`
`protected integer`	`$_queryType` DataBase Query Type 3 - DELETE DataBase Query Type 3 - DELETE	# `3`