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.