I haven't seen anything in the mysql manual that will give you that information (to the best of my knowledge).
You might have to do a get before the update and compare the fields manually. An elegant solution would be to use table triggers but this functionality is not yet available in mysql. ----- Original Message ----- From: "Wakan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2003 10:26 AM Subject: affected columns > HI, > is there a way to obtain only the affected columns after an update query? > After an update query, that involves 10 columns, I know that only 2 columns are > really updated (because the values of the other cols don't change). > I need to know the names of that changed cols, for logging purpose. > Someone can help me? > Thanks > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
