Using tablename in trigger from system

[Wolfgang Ritter]

Hi

I am using a trigger to audit the transaction on my tables.

e.g. on my user table after an update i want to have following information, as my example shows.

CREATE DEFINER = CURRENT_USER TRIGGER `test`.`dbuser_AFTER_UPDATE`
AFTER UPDATE ON `dbuser`
FOR EACH ROW

BEGIN

INSERT INTO test_audit
SET type_of_action = 'u',
tablename = 'test.dbuser',
userid = new.userid,
ip4 = null,
ip6 = null,
longitude = null,
latitude = null,
time_stamp = NOW();

END

I want to use this trigger on all my tables and i would prefer to use system variable for the table name. Until now, i didn't found the name of the variable to replace my 'test.dbuser' with some kind of a system variable.

The only information i need is the name of the table, where my trigger is connected.

Does someone know the name or where i will find it.

Thanks
Wolfgang