3 ms·
Many IDEs do throw up an "Are you sure?" confirmation prompt by default if you try to perform a DELETE or an UPDATE without a WHERE clause. I know some even _re
by rrrrrrrrrrrryan 6y ago
Many IDEs do throw up an "Are you sure?" confirmation prompt by default if you try to perform a DELETE or an UPDATE without a WHERE clause. I know some even _require_ you to have a WHERE clause by default (it's a toggleable setting, obviously), which is why you'll see some database devs add "WHERE 1=1" to the end of their queries as a matter of habit.