Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Soft delete: mark as deleted instead of removing UPDATE users SET deleted_at = NOW() WHERE user_id = 99; -- Hard delete in batches DELETE FROM logs WHERE created_at < DATE_SUB(NOW(), INTERVAL 1 YEAR) LIMIT 1000;
Result
Open