From: Dan Nelson
Date: July 23 2008 9:25pm
Subject: Re: Log
List-Archive: http://lists.mysql.com/mysql/213808
Message-Id: <20080723212509.GJ19044@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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
	dnelson@stripped