MySQL 管理工具選哪套？Navicat for MySQL 能做什麼

What's new in this version:

Navicat Premium 15.0.17 (64-bit)
- Change log not available for this version


Navicat Premium 15.0.16 (64-bit)
Improvements:
- Support Active Directory authentication method for SQL Server
- Integer column exported in Number format when exporting Excel file
- Display export profiles in the same group of queries

Bug-fixes:
- The fields of PostgreSQL compound index were displayed incorrectly
- Unable to show index fields in PostgreSQL 9.0
- Unable to set data to NULL in query results
- Crashed when clicking the ellipsis button in Custom Recordset
- Pasting data into a column cleared another column data
- Default Settings Location path was set to a wrong location for some cases
- "Floating point division by zero" error occurred when setting the dashboard background
- The file extension was missing when exporting the dashboard
- Query Parameter did not work when using a parameter twice
- "Invalid floating point operation" error occurred when adding NULL data to the chart
- Incorrect columns were displayed after clicking the Default button in the "Choose columns" window
- Minor bug fixes and improvements


Navicat Premium 15.0.14 (64-bit)
Bug fixes:
- Unable to set the identity seed and increment in PostgreSQL models
- Unable to synchronize data to MySQL 8.0.19
- Unable to connect AnalyticDB
- Unable to set SET IDENTITY_INSERT ON in Data Synchronization
- Unable to export data to .mdb files
- Minor bug fixes and improvements


Navicat Premium 15.0.13 (64-bit)
Bug-fixes:
- MySQL table row format reverted to Compact after editing
- Unknown Internal error occurred when opening Oracle tables
- Syntax error occurred when creating events
- Unable to set default value for fields in Table Designer
- Unable to show SUPER privilege for MariaDB 10.4 in the user object list
- Foreign key was dropped and added when re-comparing the model
- Data Pump Import's Table Exists Action drop-down list options were incorrect
- Minor bug fixes and improvements


Navicat Premium 15.0.12 (64-bit)
Bug fixes:
- Incorrect SQL generated when transferring Oracle tables
- Invalid XML error occurred when importing connections
- Differences was detected in re-comparison in Structure Synchronization and Synchronize to Database
- Incorrect data was updated when saving ; in a non-text field
- Unable to import data to PostgreSQL array fields
- Incorrect SQL generated for altering fields in Structure Synchronization
- Incorrect items were displayed in suggestion list when using code completion with alias
- Incorrect SQL generated when enabling "On Update Current_timestamp" in Table Designer
- Minor bug fixes and improvements


Navicat Premium 15.0.11 (64-bit)
Bug fixes:
- Query wrongly returned null results in some cases
- "," was replaced by "." when using Custom Filter in Table Viewer
- Relation attributes were wrong after reopening the logical model
- Minor bug fixes and improvements


Navicat Premium 15.0.9 (64-bit)
Bug fixes:
- Only the first batch was transferred when "Number of row per batch" was enabled
- Minor bug fixes and improvements


Navicat Premium 15.0.8 (64-bit)
Improvements:
- Added "Keep Orthogonal Layout" to Model

Bug fixes:
- Unable to update bit type data
- Minor bug fixes and improvements


Navicat Premium 15.0.7 (64-bit)
Bug fixes:
- The "Others" button was missing for PostgreSQL, Oracle and SQL Server connections


Navicat Premium 15.0.6 (64-bit)
Improvements:
- Added shortcuts for "Run Current Statement" and "Select Current Statement" in Query Editor

Bug fixes:
- "Unknown Internal Error" occurred when modeling databases
- Find bar UI issue in Data Viewer
- Unable to print table when using popup menu on Navigation pane
- Syntax error occurred when renaming index in MariaDB table
- Explain feature did not work with query parameters
- Interval type was not supported in Charts
- Highlight color issue in Filter wizard when using Dark mode
- Minor bug fixes and improvements


Navicat Premium 15.0.5 (64-bit)
Bug fixes:
- OCI Environment setting was unable to save
- "Invalid floating point operation" error occurred when resizing tables in View Builder
- Multiple primary key names were generated when exporting model to SQL files
- int8 type was converted to int8(255) when synchronizing model to PostgreSQL server
- Syntax error occurred when connecting to MySQL 4
- Minor bug fixes and improvements


Navicat Premium 15.0.4 (64-bit)
Bug fixes:
- Access violation error occurred when adding users to Navicat Cloud project
- Access Denied error occurred when designing table
- Unable to highlight field when typing in Filter's field selection list
- Wrong fields are exported to the SQL file when not all fields are selected
- Dark theme kept reverting back to Normal theme
- Wrong CREATE INDEX was generated in Model
- MySQL JSON data was truncated in Table Viewer
- Empty value was exported as **** when exporting DBF file
- Data Transfer high memory consumption issue
- Unable to connect Azure Database for MariaDB
- Run queries slow issue
- Unable to set Numeric field without precision in PostgreSQL server
- "List index out of bounds (-1)" error occurred when editing role privileges
- "Last Tab Window" option was missing


Navicat Premium 15.0.3 (64-bit)
- New Charts
- Advanced Data Transfer
- Brand new Query Builder
- Enhanced Data Modeling Tool
- Dark theme UI and Diagram
- Many other new features and improvements