[xtrm]

Hi peterlaursen, I think found two issues in lastest v11.12. Im not able to set the value through the GUI of SQLYog for:

CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

1. It still converts some reserved mySQL values to string:

ALTER TABLE `tbmdtest005` CHANGE `onupdate_at` `onupdate_at`


DATETIME DEFAULT 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP' NOT NULL;

There could be more cases like:

DEFAULT 0 ON UPDATE CURRENT_TIMESTAMP

Documentation maybe could help to get all cases, or another option should be not converting some mySQL reserved words for the default column to strings.

http://dev.mysql.com…ialization.html

2. In the GUI if we set the default value to: CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP , the value shown in the GUI default column is: CURRENT_TIMESTAMP

Maybe there could be added another column in the GUI for the ON UPDATE event statement for tables.

[xtrm]

thanks 🙂

[Author]

Posts