Consider:
update table1 set field1 = if( :var,:var,field1), ...
Can be in a procedure but doesn't have to be.
On Oct 28, 2013 5:28 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
Hi Shawn
Thanks for your reply. Maybe my example wasn't detailed enough. Basically
the snippet of the
Hello Neil,
On 10/28/2013 5:23 PM, Neil Tompkins wrote:
Hi Shawn
Thanks for your reply. Maybe my example wasn't detailed enough.
Basically the snippet of the UPDATE statement I provided shows
updating only 1 field. However in my live working example, I have about
20 possible fields that
2013/10/28 21:23 +, Neil Tompkins
Basically the snippet of the UPDATE statement I provided shows updating only 1
field.
However in my live working example, I have about 20 possible fields that
might need to be updated if the variable passed for each field is NOT NULL.
Well, maybe
2013/10/29 11:35 -0400, Shawn Green
My favorite technique is the COALESCE function for this on a column-by-column
basis
SET FieldName1 = Now(), FieldName2 = COALESCE(:MyVariable, FieldName2)
but if MyVariable is NULL, FieldName1 reflects the attempt to change, not
change.
--
MySQL
Hi,
On 10/29/2013 9:52 PM, h...@tbbs.net wrote:
2013/10/29 11:35 -0400, Shawn Green
My favorite technique is the COALESCE function for this on a column-by-column
basis
SET FieldName1 = Now(), FieldName2 = COALESCE(:MyVariable, FieldName2)
but if MyVariable is NULL, FieldName1 reflects the