News for hackers. Stuff that matters.
Re:Amazon Aurora Backtrack by wiredone on Thursday May 10, 2018 @03:37PM (#17042266)
Because nearly everyone I know has some memory where at a less experienced point in their engineering career they wrote:

delete from ImportantTable where id = 1234

... and forgot to select the second line in some query editor before running.

Re:Amazon Aurora Backtrack by ben174 on Thursday May 10, 2018 @04:41PM (#17042768)
There is usually an option to disable delete statements which do not contain a where clause. And if you really want to run that statement you'd need to write:

    delete from ImportantTable where 1 = 1;
But yea, I get your point.
Re:Amazon Aurora Backtrack by mark-wagner on Thursday May 10, 2018 @05:54PM (#17043290)
For mysql it is "--i-am-a-dummy". I wish SQL supported putting the where clause first: "where X = Y update..."