(extends Query_Builder_Where)
The Query_Builder_Delete class handles all the delete operations for the query building process. It extends the
Query_Builder_Where class, so all the methods are inherited.
The table method sets/changes the table to delete from.
Static |
No |
Parameters |
Param |
Type |
Default |
Description |
$table |
string |
required |
the table name |
|
Returns |
Returns the current instance. |
Example |
$query = DB::delete('users');
$query->table('admins');
|
The compile method returns the delete SQL query as a string.
Static |
No |
Parameters |
Param |
Type |
Default |
Description |
$db |
object |
required |
A database connection |
|
Returns |
Returns the SQL query as a string. |
Example |
$query = DB::delete('users');
$query->where('looks', 'like', '%spammer%');
$connection = Database_Connection::instance();
$sql = $query->compile($connection);
|
The reset method resets all values of the current instance.
Static |
No |
Parameters |
None
|
Returns |
Returns the current instance. |
Example |
$query = DB:delete('users');
$query->where('it_look', 'ok to me');
$query->reset();
$query->where('looks', 'like', '%bad mister%');
$connection = Database_Connection::instance();
$sql = $query->compile($connection);
|