sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

Fat finger prevention: identify potential user error on bulk update

Open fr3dastaire opened this issue 1 year ago • 1 comments

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.

fr3dastaire avatar Mar 04 '24 12:03 fr3dastaire

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

williamdes avatar Jan 18 '25 00:01 williamdes