On Friday, March 22, 2024, Jamie Thompson <
jthompson.neuk@gmail.com> wrote:
Earlier today, I was running some sql for someone which they had submitted as:
> UPDATE tablename SET col1 = val1 AND col2 = val2 WHERE id = X
I presume these columns are booleans. So you wrote something like:
Set col1 = ( true and false = true )
Which in this case must coincidentally have produced whatever boolean value already existed in col1.
David J.