3 ms·
SELECT COUNT(1) FROM table -- UPDATE table SET col='val' WHERE 1=1
by password4321 5y ago
SELECT COUNT(1) FROM table
-- UPDATE table SET col='val'
WHERE 1=1
- worble 5y agoBEGIN TRANSACTION UPDATE table SET col='val' WHERE 1=1 ROLLBACK
- tomrod 5y agoExactly!
- password4321 5y agoDefinitely better, when you can afford the overhead!