Kotchasan\QueryBuilder\DeleteBuilder

DeleteBuilder creates DELETE queries.

Usage

use Kotchasan\Database;

$db = Database::create();

// Basic DELETE
$affected = $db->delete('users')
    ->where('id', '=', 1)
    ->execute();

echo "Deleted {$affected} row(s)";

Main Methods

delete() / where() / limit()

$db->delete('tablename')
    ->where('column', '=', 'value')
    ->limit(10)
    ->execute();

Examples

Delete Expired Records

$affected = $db->delete('sessions')
    ->where('expires_at', '<', date('Y-m-d H:i:s'))
    ->execute();

Delete with Limit

// Delete oldest 100 records
$affected = $db->delete('logs')
    ->where('created_at', '<', '2023-01-01')
    ->orderBy('created_at')
    ->limit(100)
    ->execute();

Warnings

⚠️ Important: Always include where() to avoid deleting all rows.

❌ $db->delete('users')->execute(); // Deletes everything!
✅ $db->delete('users')->where('id', '=', 1)->execute();

Related Classes

• QueryBuilder Overview
• SelectBuilder
• InsertBuilder
• UpdateBuilder