How to use trigger to register user name who insert or modify a row of

[Cary Martin]

another user said that they would use this for using correct username in trigger:

SELECT SUBSTRING_INDEX(USER(),'@',1) from dual,

actually if you want to use it in a trigger, it has to be this:

SUBSTRING_INDEX(USER(),'@',1)

something like this...

delimiter $$
DROP TRIGGER IF EXISTS `upTrig`$$
CREATE TRIGGER `upTrig`
BEFORE UPDATE ON `table_data`
FOR EACH ROW
BEGIN
IF(OLD.inserted_by IS NOT NULL) THEN
SET NEW.modified_by = SUBSTRING_INDEX(USER(),'@',1);
END IF;
END $$
delimiter ;