Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

time stamp and currently logged id user

mung-gee's profile image mung-gee posted 3 months 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 3 months 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 3 months 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 3 months ago Permalink

Sorry, no clue.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.