In the last episode (Jul 23), Pedro Belmino said: > I do a system log of their log everything that is done(INSERTS, UPDADES > and DELETES). Okay, can be done with trigger. But I need to know who > performed the operation. How can I get get it inside the trigger?
Try the USER() or CURRENT_USER() functions: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_user http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_current-user -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]