MySQL Forums
Forum List  »  Triggers

Re: How to use trigger to register user name who insert or modify a row of
Posted by: Peter Brawley
Date: November 11, 2015 04:41PM

User() returns the username on the connection; substring_index(user(),'@',1) returns the name portion of that spec. But if an app is invoking the Update, that will return the same value for every app user---the value used by the app to connect. So the Trigger appears to be useless.



Edited 1 time(s). Last edit at 11/11/2015 11:01PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to use trigger to register user name who insert or modify a row of
935
November 11, 2015 04:41PM


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.