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

What's new in this version:

Navicat for MySQL 12.0.20 (64-bit)
- Change log not available for this version

Navicat for MySQL 12.0.19 (64-bit)
Bug Fixes:
- Unable to zoom in/out Query Editor using mouse wheel
- Unable to connect Sphinx servers
- Swapping connections did not work when re-comparing in Data Synchronization
- Syntax errors occurred when running query in some cases
- Unknown Internal error occurred when performing Structure Synchronization
- No records was transferred when the target connection was using HTTP Tunnel
- Query syntax highlight was wrong after switching tabs
- DateTime field Not Null checkbox unchecked wrongly in Table Designer
- Unable to export table to xlsx with name longer than 31 characters
- Hanged when searching in Table Viewer in some cases

Navicat for MySQL 12.0.18 (64-bit)
Bug Fixes:
- The database/schema combo-box did not work in Query
- Manual refresh did not work in Server Monitor when auto-refresh was enabled
- Unknown Internal Error occurred when performing Structure Synchronization

Navicat for MySQL 12.0.17 (64-bit)
Bug Fixes:
- Structure Synchronization detected differences wrongly in some cases
- Record delimiter was wrong when exporting to text file using Automation
- Table Viewer moved back to the first page when refreshing a table
- Characters displayed wrongly in Table Viewer
- Unable to select fields when exporting to Excel file

Navicat for MySQL 12.0.16 (64-bit)
- Change log not available for this version

Navicat for MySQL 12.0.15 (64-bit)
- Error occurred when deleting INT field value in Table View

Navicat for MySQL 12.0.14 (64-bit)
Bug Fixes:
- Wrongly shown differences when synchronizing structure
- The DDL tab in Information pane did not updated after saving changes in sub forms
- Unknown Internal Error occurred when synchronizing structure/data in some cases
- Unable to schedule Data Synchronization profiles
- Syntax error occurred when filtering with ' character in Table Viewer
- Compared table comments in Structure Synchronization
- Input decimal separator issue in Table Viewer
- Unable to import date from Excel to VARCHAR field
- Query Builder loading was slow
- Custom backup file name was ignored when scheduling in Automation
- Re-registration issue
- Unable to create new table in Import Wizard in some cases

Navicat for MySQL 12.0.13 (64-bit)
Bug Fixes:
- Table triggers was not included when backing up tables
- Auto increment field was ignored when importing
- Unable to set the default value of TEXT/BLOB field for MariaDB 10.2.1 or above
- Navicat hanged when running a query export profile in some cases
- Error occurred when running LOAD DATA LOCAL queries
- Special characters were garbled when exporting Access files
- Unknown Internal error occurred when exporting Access files
- Unknown Internal error occurred when saving changes in Table Designer
- "Too many client tasks" error occurred when importing Access files
- Double-quote encased text fields were split into new records when importing a record which multiple lines
- Syntax error occurred when performing data transfer in some cases
- Unknown Internal error occurred when adding multiple records in Table Viewer
- Two identical functions declared as different in Structure Synchronization

Navicat for MySQL 12.0.11 (64-bit)
Bug Fixes:
- Unable to open Information pane by context menu
- Unable to import fixed width text file in some cases
- Access Violation error occurred when creating models / tables in some cases
- Access Violation error occurred after Navicat was idle
- Unable to import the CDATA data in XML files
- Number values were exported as text in Excel files
- Code completion did not work for alias in SQL Editor
- Beautify SQL did not format multiple statements properly in SQL Editor
- Unknown Internal error occurred when running query with parameters
- Table menu displayed wrong item in some cases
- Unknown Internal error occurred when running old version export profiles in Automation
- Unknown Internal error occurred when opening tables in some cases
- "_Navicat_Temp_Stored_Proc() does not exist" error occurred when saving functions
- High memory usage issue in Data Synchronization
- "Use empty string as NULL" option did not work in Import Wizard
- Unknown Internal error occurred when writing query in some cases
- Unknown Internal error occurred when backup in Automation in some cases
- Hang issue occurred when launching Import Wizard
- Unable to connect with SSL in some cases

Navicat for MySQL 12.0.10 (64-bit)
- Error occurred when opening MySQL databases in HTTP connection if enabled "Encode outgoing query with base64" setting
- Unable to import Chinese characters from Excel files
- Incorrect date and decimal formats in exported Excel files
- Filter criteria settings were removed when applying sorting on column
- Error occurred when duplicating MySQL tables in HTTP connection
- Unknown Internal Error occurred when executing old version export profiles in Batch Job
- Save dialog did not pop up when closing backup profiles after editing
- Unknown Internal Error occurred when loading Filter profiles in Table Viewer
- File path and file name were not saved in Export profiles
- Unknown Internal Error occurred when there was multiple statements in Query
- Incorrect field names were shown in code completion suggestion list
- Unable to attach the report PDF file in notification email

Navicat for MySQL 12.0.9 (64-bit)
Bug Fixes:
- "Unknown Internal Error" occurred when typing statement in SQL Editor
- Unable to show field names in data pipeline after editing SQL in Report
- Beautify SQL formatted the statement wrongly in some cases
- Sorting by modified/create date did not work for details view in main window
- Connection coloring displayed wrong color in some cases

Navicat for MySQL 12.0.8 (64-bit)
- Wrong table showed when comparing tables in Data Synchronization in some cases
- Unable to import special characters from Excel
- Unable to paste multiple records in Table Viewer
- Created Batch Jobs did not show in Standard Edition
- "Unknown Internal Error" occurred when importing files
- View Builder locked up when re-open for editing in some cases

Navicat for MySQL 12.0.7 (64-bit)
Bug Fixes:
- "Access violation" error occurred when create new query/view
- Enum value drop-down list was missing for MariaDB in Table Viewer
- Wrongly showed primary key warning in some cases
- Unable to type some characters in editor when using international keyboard
- Unable to edit connection settings in some cases
- Information Pane did not appear in some cases
- Internal error occurred when importing CSV files
- Cell values froze when scrolling in grid view

Navicat for MySQL 12.0.6 (64-bit)
Bug Fixes:
- 1142 error occurred when dumping SQL files
- 1142 error occurred when backing up databases
- Failed to load Data Synchronization profiles
- Data display issues in table viewer
- Minor bug fixes and improvements

Navicat for MySQL 12.0.5 (64-bit)
- New UI/UX
- On Startup: open favorite tabs automatically when Navicat launches
- Code Snippet
- Advanced Code Completion with better suggestions
- Brand new Structure Synchronization: visually show side-by-side DDL comparison between two databases
- Brand new Data Synchronization: show particular status to distinguish the differences between records easily
- New Automation: easy to find desired profiles and create automated batch jobs
- Responsiveness and performance improved
- Many other new features and improvements

Navicat for MySQL 11.2.16 (64-bit)
Bug Fixes:
- Error occurred when exporting with Time field type
- "Argument out of range" occurred when running "Reverse Database to Model"
- Minor bug fixes and improvements

Navicat for MySQL 11.2.15 (64-bit)
- Minor bug fixes and improvements

Navicat for MySQL 11.2.11 (64-bit)
- Bug Fixes: Copy and paste issue in Table Viewer's Memo Editor