CODEWITHSUNDEEP
mysqlmysql-workbench
xy36
xy36

Reputation: 325

settings of columns are not saved in MySQL Workbench 6.3

iam working with a MySQL-server and use the MySQL Workbench 6.3 to configure and manage the server. I created some columns, which are working, but additionally I need another column for a timestamp of the system (in milliseconds). So I added another column "log" with the datatype "TIMESTAMP(6)" and chose as Default/Expression "CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP". Then I clicked on apply and the system said:"Apply changes to ...". Hence the changed should be applied, but the configuration of the datatype TIMESTAMP(6) and the Default/Expression is not saved.

So the saved datatype is just "TIMESTAMP" and the Default/Expression is "NULL". Anyone knows why these settings are not saved?

Upvotes: 0

Views: 304

Answers (1)

xy36
xy36

Reputation: 325

For everyone who has the same problem, I found a solution. It didnt apply the values, because the datatype and expression were different...

I needed to add the 6 to the expression as well, like:

TIMESTAMP(6) | CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6)

Now it is working for me!

Upvotes: 1

Related Questions