3 ms·
Most systems I work in raise a warning when an update or insert is missing a where clause. For all rows, we typically just use `where 1=1` to encompass all row
by tomrod 3y ago
Most systems I work in raise a warning when an update or insert is missing a where clause.
For all rows, we typically just use `where 1=1` to encompass all rows. Allows for cleaner readability too as each clause can be separated by an AND