Is it helpful to use cursor in triggers for auditing? If Yes then How?

Is it possible to Use cursor in triggers in MySQL? Is it recommended? as someone told me its helpfull to开发者_运维百科 use cursor in triggers for auditing

I need this for auditing...

EDIT

is it helpful to use cursor in triggers for auditing? If Yes then How?

Please help .. Thank You

Short answer yes, what else you wanna know?

There's can you and should you. You can probably put system calls and web service calls in there too. You're taking just about the heaviest drag on SQL database performance and inserting it into the feature that's considered to be the lightest-weight, fastest feature. You'd best be prepared to have a very good reason.