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.

ENTERDATE Not Changing

levolka's profile image levolka posted 4 weeks ago in General Permalink

Hi,

On previous versions when I update DATA and post it, the ENTERDATE was changing. But on version 10.2.0.5722 though I update DATA and post the ENTERDATE is not changing. Cause of that I'm not sure it's updated and post or not.

I'm attached screen shot for more understandable.

(If I do grammer mistakes forgive me please)

1 attachment(s):
  • Capture
ansgar's profile image ansgar posted 4 weeks ago Permalink

Does that "ENTERDATE" have an "ON UPDATE CURRENT_TIMESTAMP()" clause or similar?

You should probably post the CREATE TABLE code here.

levolka's profile image levolka posted 4 weeks ago Permalink

I was expecting or thinking like that have attribute like that "Does that "ENTERDATE" have an "ON UPDATE CURRENT_TIMESTAMP()" clause or similar?"

But it was my mistake. I learned it's something different.

Maybe it was a bug the ENTERDATE changing on previous versions.

We can close the ticket, thanks for help.

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