Is it posible to make :
update tab1 (col1, col2) values (:myvar1, :myvar2) where id=1;
But I want to update only columns where myvarX is not NULL,
when the value is NULL I want to let previous value of column.
I know when I divide my query :
if (myvar1 <> NULL) then
update tab1 (col1) values (:myvar1) where id=1;
if (myvar2 <> NULL) then
update tab1 (col2) values (:myvar2) where id=1;
it will work, but when I have some UPDATE trigger defined for the table,
this trigger will fire for every update and I prefer when it fires only once.
Thank you, for your suggestions.
Best regards, Dusan
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
