Subject | Using one prepared statement for updating different fields. |
---|---|
Author | ariel.sakin |
Post date | 2007-05-21T15:18:29Z |
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
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