UPDATE without WHERE: what MySQL's safe-updates mode stops, and what it lets through
DEV Community
UPDATE without WHERE: what MySQL's safe-updates mode stops, and what it lets through
22 writes with sql_safe_updates=1 on MySQL 8.4 and MariaDB 11.4: WHERE 1=1 is blocked, WHERE id > 0 and LIMIT 100000 rewrite every row.
0 comments
No comments yet.