Error in exporting mysql timestamp type format and some feature suggestions

[shequeen]

My problem is:
When the field type of mysql database is:
...``update_time`` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'real time',
Export time is:
... '2025-09-29T08:21:21.000+00:00');
However, the sql statement in this format cannot be imported directly and correctly, so I need to manually change it to:
... '2025-09-29 08:21:21');

==========
Here are some of my other feature suggestions:

1. Visual ddl statement display is added to the table structure. For developers, show create table is simpler, more comprehensive and more efficient than listing fields in the drop-down menu. It is especially convenient to view the comments of an enumeration or type field frequently. Please refer to navicat for details.

2. A comment column is added to the visualization of alter table, which supports the modification of comments.

Finally, thanks to the excellent plug-in developed by the author, I like it very much.

[mikeburgh]

Thanks, I have released version 1.17.16 which fixes the timezone format in mysql, it should resolve it for you.

I am working on rebuilding the table editing/creation at the moment.. both those issues I am looking to address (show the current DDL if it's an edit) and support comment editing adding where supported.

Are you looking for the table DDL just in editing a table or somewhere else as well ?