Re: affected columns

2003-07-29 Thread Egor Egorov
Wakan <[EMAIL PROTECTED]> wrote: > is there a way to obtain only the affected columns after an update query? Instant answer: no. You could do some selects and compare the difference. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensi

Re: affected columns

2003-07-29 Thread Matthew
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.