Hi, frequently i have accidents with DELETE/UPDATE commands. In fact, sometimes in the last 8 or 9 years (ok, a lot of times) I forget the entire WHERE clause or have a “not so perfectly“ WHERE clause, with an awful suprise. There’s no words to figure the horror ever time i see that the number of affected rows its not 1 or two how expected, but the entire table. So I planned to make a hack to make the “LIMIT” directive available to “DELETE” command.
So, can anyone help-me in how to do this ? This its my plan: 1) change the lex grammar (wheres the file ?) 2) change the parser to accept the new grammar 3) change the executor to stop after “n” successful iterations. Is this correct ? Greets, -- Daniel Loureiro ------------------------------ http://diffcoder.blogspot.com/
