Code snippets
Code snippets
Copy-ready answers to everyday coding questions, each with a short explanation. Laravel, PHP, JavaScript, SQL, Bash and more.
2 snippets tagged #cleanup · Show all
SQL
October 20, 2026
MySQL find and delete duplicate rows keeping the lowest id
Finds rows that repeat a column value and deletes all but the one with the smallest id. Run the SELECT first to preview what will be removed, and back up the ta...
-- Preview duplicates
SELECT email, COUNT(*) AS total
FROM users
GROUP BY email
Bash
October 17, 2026
Linux find files by name, size or age and delete them safely
find searches by name, size and modified time. Run it without -delete first to preview what matches.
find . -name "*.log" # by name
find /var/log -type f -size +100M # larger than 100 MB
find . -type f -mtime +30 # older than 30 days
find . -name "*.tmp" -type f -print # preview first