>>>> 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
