Let's say i want to do 3 updates in a single update statement.
update table set columnB = 'abcd' where columnA in ('1','2','3')
Assume columnA='1' exists but not for '2' or '3'.
The second update is not valid(the key doesn't exist in the db). The third update is also not valid.
So i don't want any update to happen. I tried doing this but it didn't work:
"update statement to update 3 rows, 2 of which don't exist."