Subject Using one prepared statement for updating different fields.
Author ariel.sakin
Hello,
I have the following prepared statement:
UPDATE TABLE requests SET f1=?, f2=?, f3=?

Where f1 f2 and f3 are columns that may contain large string values
(some of them may be BLOBs). In reality I have 20+ columns.

I am looking for a way of using that statement for updating my table
without having to provide it with all the values all the time. for
example, if I need to update only f1 and f3 I don't want to be forced
to pass the value for f2 that do not need to be changed.
Writing a different statement for every column is not a good option
since sometimes I need to update 15 out of 20 fields and the overhead
of running 15 queries is too large.

Is there a way to do it?

Thanks,
Ariel Sakin