Fat finger prevention: identify potential user error on bulk update

[fr3dastaire]

Hi there,

Yesterday by copying & pasting, I ended up in this situation:

UPDATE table
SET field = 1
WHERE condition1;
AND condition 2;

Notice the ";" in after condition1. You already know how this ended.

The request is to identify this potential harmful mistakes and prompt a confirmation.

Thanks for reading.

Cheers,
J.

[williamdes]

Let's see how the parser can handle the error message hint