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
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.