Navicat for MySQL (64-bit)

What's new in this version:

Navicat for MySQL 17.1.12 (64-bit)
Fixed:
- The "New Table" column was empty when dragging and dropping a file to import
- Unable to handle CASE statement when using Query Builder
- Access Violation error occurred when copying procedure results
- Minor bug fixes and improvements


Navicat for MySQL 17.1.11 (64-bit)
Fixed:
- Unable to backup with Automation
- Minor bug fixes and improvements


Navicat for MySQL 17.1.10 (64-bit)
Fixed:
- Multi-line editing did not work in Query Editor
- Crashed when deleting "My Connections"
- Crashed when copying UPDATE statements from query results
- Minor bug fixes and improvements


Navicat for MySQL 17.1.9 (64-bit)
Fixed:
- Crashed when sorting data
- Incorrect database name assigned when using "Synchronize Database To Model"
- Minor bug fixes and improvements


Navicat for MySQL 17.1.7 (64-bit)
Fixed:
- Unable to display Chinese characters in the bookmark outline of the data dictionary PDF file
- Unable to import Access file when 32-bit Office installed
- The Fields pane always displayed when opening table
- Column sizes did not persist when refreshing table
- Crashed when using "Filter & Sort"
- Minor bug fixes and improvements


Navicat for MySQL 17.1.5 (64-bit)
Fixed:
- Response was slow when hovering over the menu bar
- Crashed when starting Navicat in some cases
- Minor bug fixes and improvements


Navicat for MySQL 17.1.3 (64-bit)
Fixed:
- Unable to import all records from a file in some cases
- Minor bug fixes and improvements


Navicat for MySQL 17.1.2 (64-bit)
Fixed:
- Source connection info was not pre-populated in the Structure Synchronization window
- Model diagram disappeared when hovering over
- Minor bug fixes and improvements


Navicat for MySQL 17.1.0 (64-bit)
Main New Features:
- Support Alibaba Cloud PolarDB for MySQL, Alibaba Cloud PolarDB for Xscale
- Support Visual Query Explain for OceanBase (MySQL Mode)
- Enhanced Query Editor
- Enhanced BI Feature
- New Filter & Sort Layout
- Many other new features and improvements


Navicat for MySQL 17.0.13 (64-bit)
Fixed:
- Crashed when clicking the Options button in the Data Generation window
- Minor bug fixes and improvements


Navicat for MySQL 17.0.12 (64-bit)
Fixed:
- Foreign keys were not deleted when deleting the parent table in the model
- Minor bug fixes and improvements


Navicat for MySQL 17.0.8 (64-bit)
- Invalid file format error occurred when opening a model workspace
- Crashed when opening a model workspace in some cases
- Minor bug fixes and improvements


Navicat for MySQL 17.0.7 (64-bit)
Fixed:
- Keyboard support failure in Data Viewer
- The reference field was not updated when changing the primary key field in the model
- Non-filtering objects did not hide in the overview navigator of ER Diagram
- Minor bug fixes and improvements


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


Navicat for MySQL 17.0.3 (64-bit)
Main New Features:
- All-New Model Workspace
- Data Profiling
- Data Dictionary
- Query Pinned Result
- Visual Query Explain
- Table Profile
- Navicat URI
- Manage Connection
- Enhanced BI Feature
- Focus Mode
- Many other new features and improvements


Navicat for MySQL 16.3.9 (64-bit)
Fixed:
- Incorrect SQL format when dumping Mariadb table
- Syntax error occurred when transferring tables with escape characters
- Minor bug fixes and improvements


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


Navicat for MySQL 16.3.7 (64-bit)
Fixed:
- Crashed when importing paradox files
- Failed to import JSON file from web service
- Refresh button did not work in Server Monitor
- Some labels disappeared after adding the chart to the dashboard
- Unable to display proportion percentages in the chart axis
- Minor bug fixes and improvements


Navicat for MySQL 16.3.5 (64-bit)
Fixed:
- The percentage values shown in the chart were incorrect
- Not all data was imported when scheduling import
- Unknown Internal Error occurred when importing data
- The comment code shortcut did not work in some cases
- Unknown Internal Error occurred when transferring data
- Minor bug fixes and improvements


Navicat for MySQL 16.3.3 (64-bit)
Improved:
- Support enabling or disabling "Detect Data Types" in Import Wizard
- Support ssh agent using pageant unix mode

Fixed:
- Minor bug fixes and improvements


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


Navicat for MySQL 16.3.0 (64-bit)
Improved:
- Support setting MySQL descending primary key

Fixed:
- Minor bug fixes and improvements


Navicat for MySQL 16.2.11 (64-bit)
Fixed:
- Crashed when opening Charts workspaces in some cases
- Missing parameters when transferring MariaDB Functions
- Crashed when scheduling import jobs
- 1064 error occurred when running query to create stored procedure in some cases
- Missing records when importing files in some cases
- Special characters were garbled when using double-click to add a snippet to the query
- Incorrect database list was shown in the connection window when using dark mode


Navicat for MySQL 16.2.10 (64-bit)
Fixed:
- Crashed when importing Access file
- Minor bug fixes and improvement


Navicat for MySQL 16.2.8 (64-bit)
Improvements:
- Auto guess field types when importing xlsx files

Fixed:
- Beautify SQL incorrectly added spaces between the function name and parentheses
- Unable connect to MySQL via SSH tunnel in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.2.7 (64-bit)
Fixed:
- Incorrectly triggering code completion when pressing ENTER in Query Editor
- Minor bug fixes and improvements


Navicat for MySQL 16.2.6 (64-bit)
Fixed:
- Unable to close tabs in some cases
- Slashes () were removed from triggers when synchronizing MariaDB structures
- Minor bug fixes and improvements


Navicat for MySQL 16.2.5 (64-bit)
Fixed:
- Cannot type a new name for the table in Import Wizard.
- Minor bug fixes and improvements.


Navicat for MySQL 16.2.3 (64-bit)
Fixed:
- Expressions for virtual columns were truncated
- Minor bug fixes and improvements


Navicat for MySQL 16.2.2 (64-bit)
Improved:
- Support unix socket forwarding in SSH

Fixed:
- Minor bug fixes and improvements


Navicat for MySQL 16.2.1 (64-bit)
- Support sequence design for MariaDB
- Show fields, indexes and more under tables in Navigation Pane
- Minor bug fixes and improvements
- Navicat for Redis is released


Navicat for MySQL 16.1.15 (64-bit)
Fixed:
- High CPU usage when using SSH connection
- Minor bug fixes and improvements


Navicat for MySQL 16.1.12 (64-bit)
Fixed:
- Query Builder window was larger than the screen in some cases
- Unable to display the data differences of TEXT fields in Data Synchronization
- The second field was selected when adding a sort condition in Table Viewer
- Crashed when stopping Data Transfer process
- Minor bug fixes and improvements


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


Navicat for MySQL 16.1.9 (64-bit)
Fixed:
- Memory utilization issue
- Table Viewer did not show the SQL if errors occurred
- Minor bug fixes and improvements


Navicat for MySQL 16.1.8 (64-bit)
- Unable to save changes after deleting a cell value in Table Viewer
- Access violation error occurred when opening a model
- Minor bug fixes and improvements


Navicat for MySQL 16.1.7 (64-bit)
Improved:
- Support MariaDB UUID type

Fixed:
- Cannot display column comment when mouse over in dark mode
- Data Synchronization did not work in Automation
- "Failed to send mail. Stream error." occurred when sending email
- Minor bug fixes and improvements


Navicat for MySQL 16.1.6 (64-bit)
Fixed:
- "Cannot open source table" error occurred when using Condition Query in Import Wizard
- Exporting to Excel file was slow
- Minor bug fixes and improvements


Navicat for MySQL 16.1.4 (64-bit)
Fixed:
- 1267 error occurred when clicking the "Users" button
- Bar chart label display issue
- Unable to export Excel file in some cases
- Hanged when transferring tables
- Minor bug fixes and improvements


Navicat for MySQL 16.1.3 (64-bit)
Fixed:
- Unable to connect server using HTTP tunnel in some cases
- Font size issue in Form View
- Buttons in the lower right corner of the main window were missing in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.1.2 (64-bit)
Fixed:
- Crashed when changing the chart type in some cases
- Hanged when deleting a table in Query Builder
- Text color issue in Dark Mode
- Unable to connect AWS RDS database via SSH
- Backup and Dump SQL File was slow in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.1.1 (64-bit)
Fixed:
- Unable to open the objects in the "Find in Database" window
- The first number of every value in the list was removed in the table filter
- Unknown Internal Error occurred when updating query results in some cases
- Unable to use "Copy As" in View results
- Crashed when opening functions in some cases
- Unknown Internal Error occurred when foreign key selection window popped up
- Crashed when clicking on the value box in table filter
- Cannot retain the window size and position for existing objects
- Minor bug fixes and improvements


Navicat for MySQL 16.1.0 (64-bit)
Main New Features:
- Support OceanBase Community Edition
- Support Trend Line for several chart types
- Support adding On-Prem Server with URI
- Allow skip preview of changes in data sync
- Enhanced responsiveness and performance
- Improved UI/UX
- Minor bug fixes and improvements


Navicat for MySQL 16.0.14 (64-bit)
Fixed:
- Query parameters did not work in some cases
- Decimal precision issue when importing from Excel files
- Minor bug fixes and improvements


Navicat for MySQL 16.0.12 (64-bit)
Fixed:
- Extra commas were added to the script in Structure Synchronization
- Unknown Internal Error occurred when exporting large amount of data
- Unable to sign in Subscription plan
- Minor bug fixes and improvements


Navicat for MySQL 16.0.11 (64-bit)
Fixed:
- Crashed when running Automation in some cases
- Missing the first record when import
- Unable to locate project when running batch job
- Unable to get table information when scheduling data synchronization
- Refresh button ran all SQLs in Query Editor
- .0000 data export issue
- Function execution message log issue
- Access Violation error occurred when removing default value
- Navicat exited when clicking the Type column in Table Designer
- Crashed when batch querying tables with FK dependency
- Minor bug fixes and improvements


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


Navicat for MySQL 16.0.9 (64-bit)
Fixed:
- The "Compare" button did not work in Data Synchronization in some cases
- "Couldn't open known_hosts file" error occurred when the SSH path contained Chinese characters
- Minor bug fixes and improvements


Navicat for MySQL 16.0.7 (64-bit)
Fixed:
- Unable to show utf8mb4 data
- Minor bug fixes and improvements


Navicat for MySQL 16.0.5 (64-bit)
Fixed:
- Connection encoding issue in Navicat Cloud
- Connection password issue when updating connection in Navicat Cloud
- Error occurred when synchronizing to Navicat Cloud
- Minor bug fixes and improvements


Navicat for MySQL 16.0.4 (64-bit)
Fixed:
- Syntax error occurred when importing data to MySQL table
- Notification Email authentication failed in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.0.3 (64-bit)
New Features:
- New Data Generation Tool
- Enhanced Charts Feature
- Support of Navicat On-Prem Server

Additional Features:
- Connection Profiles
- Field Information Pane
- Query Execution Summary
- Navicat On-Prem Server is released
- Many other new features and improvements


Navicat for MySQL 15.0.27 (64-bit)
Fixed
- Double foreign key lines were printed when exporting a model to a PDF file
- Access violation error occurred when searching in the Backup's Object Selection tab
- No data value on the label when exporting a chart to a PDF file
- Unable to rename a view inside a group in Navicat Cloud
- Minor bug fixes and improvements


Navicat for MySQL 15.0.26 (64-bit)
Improvements:
- Support tunneling on PHP 8

Bug fixes:
- Unknown Internal Error occurred when importing Excel file in some cases
- An empty string was not quoted when exporting to a text file
- Query was garbled when the system locale set to Japanese
- Export/Import profile did not work if it was copied to Desktop
- Minor bug fixes and improvements


Navicat for MySQL 15.0.25 (64-bit)
Bug fixes:
- Empty rows were added when exporting more than 1.05 M records to Excel file
- Error occurred when using Recordset Generator to generate a record set for the Date field
- Hanged when designing a table with many fields
- Relation lines were disappeared after saving and reopening Logical Model
- Minor bug fixes and improvements


Navicat for MySQL 15.0.23 (64-bit)
Fixed:
- Functions were not properly saved as the default value in MariaDB
- ER diagram was reloaded when clicking the Design Table button
- Unable to toggle "Virtual Type" in an existing table
- Error 1227 occurred when creating or designing a table
- Minor bug fixes and improvements


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


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


Navicat for MySQL 15.0.20 (64-bit)
Fixed:
- Flashed in dark mode
- "Unallowed argument in list..." error when running export / import schedule
- Unable to load version 10 data synchronization profiles
- Differences were incorrectly detected in Synchronize to Database
- Minor bug fixes and improvements


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


Navicat for MySQL 15.0.18 (64-bit)
Bug-fixes:
- Unable to show records that had -1 data in Table Viewer
- "Drop target objects before create" option did not work in Data Transfer
- Memory leak issue when enabled code completion
- "Unknown Internal Error (A70529211102SE)" error occurred when exporting / importing data
- Slow issue when transferring large tables
- Unable to show the inputted text in Filter Wizard
- Error occurred when filtering data by right-clicking a cell in Table Viewer
- Inserted records to the wrong table when transferring data to the target table with a different name
- Unable to connect MySQL server when using TLSv1.2
- Minor bug fixes and improvements


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


Navicat for MySQL 15.0.16 (64-bit)
Improvements:
- Integer column exported in Number format when exporting Excel file
- Display export profiles in the same group of queries

Bug-fixes:
- 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 for MySQL 15.0.14 (64-bit)
Bug fixes:
- Unable to synchronize data to MySQL 8.0.19
- Unable to connect AnalyticDB
- Unable to export data to .mdb files
- Minor bug fixes and improvements


Navicat for MySQL 15.0.13 (64-bit)
Bug fixes:
- MySQL table row format reverted to Compact after editing
- 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
- Minor bug fixes and improvements


Navicat for MySQL 15.0.12 (64-bit)
Bug fixes:
- 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
- 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 for MySQL 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
- Minor bug fixes and improvements


Navicat for MySQL 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 for MySQL 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 for MySQL 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 for MySQL 15.0.5 (64-bit)
Bug fixes:
- "Invalid floating point operation" error occurred when resizing tables in View Builder
- Multiple primary key names were generated when exporting model to SQL files
- Syntax error occurred when connecting to MySQL 4
- Minor bug fixes and improvements


Navicat for MySQL 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
- "List index out of bounds (-1)" error occurred when editing role privileges
- "Last Tab Window" option was missing


Navicat for MySQL 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