3 ms·
Not sure if it qualifies, but I find humorous the mysql --i-am-a-dummy flag. > Allow only those UPDATE and DELETE statements that specify which rows to modify
by mhitza 5y ago
Not sure if it qualifies, but I find humorous the mysql --i-am-a-dummy flag.
> Allow only those UPDATE and DELETE statements that specify which rows to modify by using key values.
- DocTomoe 5y agoI'm fairly sure that many long-time db admins wished that was the default setting.
- throwanem 5y agoI will to my dying day start writing these statements in the console like UPDATE whatever_table SET WHERE condition; or DELETE FROM WHERE condition; and then go back and fill in the rest. I've long since forgotten what I originally fat-fingered to make this seem a habit worth having, but it must've really ruined my day - in any context where one or two errant keystrokes would be enough to execute the query, I never don't do it this way. Don't even have to think about it, it's just what my hands do.