Can not detect the prop "default 0 ON UPDATE CURRENT_TIMESTAMP" (5174)

[expired user #10846]'s profile image [expired user #10846] posted 7 years ago in General Permalink

version:5174 database:MySQL 5.6.24

I created a column named update_at with prop default 0 ON UPDATE CURRENT_TIMESTAMP (use another tool named yii2 migrate).

My excepted is :

'updated_at' TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP

But HeidiSQL has seems to show me a wrong info , just has default 0:

'updated_at' TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'

In phpMyAdmin it's right (you can find this in Attachments)

Is this a bug ?

Thank you for reply.

2 attachment(s):
  • phpmyadmin
  • heidi
[expired user #10846]'s profile image [expired user #10846] posted 7 years ago Permalink

Even if I change it by Heidi, it is also wrong

1 attachment(s):
  • heidi
[expired user #1502]'s profile image [expired user #1502] posted 7 years ago Permalink

Just curious, why would you like to have these zeroes for the updated_at instead of NULLs?

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