time stamp and currently logged id user

mung-gee's profile image mung-gee posted 2 years ago in General Permalink

Hi there

I am trying to have my tables automaticaly timestamped plus the currently logged in user SELECT Current_user()

How can I do that with mySql

thank you

ansgar's profile image ansgar posted 2 years ago Permalink

You can set an expression for DATETIME columns:

Description

Not sure for the current_user() question - probably newer servers also allow that.

mung-gee's profile image mung-gee posted 2 years ago Permalink

Hi Ansgard Thank you. Do you have a suggestion in which Delphi sql event I could set it manually?

ansgar's profile image ansgar posted 2 years ago Permalink

Sorry, no clue.

Please login to leave a reply, or register at first.