MySQL Forums
Forum List  »  Newbie

TRIGGER
Posted by: P L
Date: March 15, 2015 03:09PM

Hello Boyz and Girlz!

I'm a newbie so thats why Im here.
I need to create TRIGGER that will be kind of LOG. I want it to check what users do. Sooo...

I made something like that

CREATE TABLE Log (
UserName varchar(20),
Action varchar(20),
Date datetime);


CREATE TRIGGER Watch AFTER UPDATE ON ORDERS
AS INSERT INTO Log(UserName, Action, Date) VALUES (SYSTEM_USER, ???, GETDATE());

this fragment of SQL code worked in MSSQL Server but here in MySQL didnt.

My problem is that i dont know the correct function to get UserName and kind of action this user use.



COULD YOU HELP ME?
Your faithfully NEWbIE

Options: ReplyQuote


Subject
Written By
Posted
TRIGGER
P L
March 15, 2015 03:09PM
March 15, 2015 05:09PM
March 15, 2015 10:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.