Recently, Navicat released its Navicat MySQL GUI version 7.2.9 for windows.
Navicat MySQL supports multiple platforms and multiple MySQL servers online. With the data export/import function, you can use ODBC to import data. It supports more than 18 common data formats.
Navicat is a set of graphical system management and development tools for MySQL databases. It can be executed on Linux, Unix, Mac OS X, and Windows platforms. It supports the connection of multiple MySQL servers, it can also connect to multiple remote or local databases to help users easily establish, query, organize, and access databases.
Supports Chinese and intuitive Interfaces
Because the MySQL database does not have a built-in graphical management interface, many solutions that boast friendly interfaces compete with each other, but can be executed on multiple operating system platforms, only a limited number of products can properly support Chinese characters. In the Query Browser Query interface launched by MySQL, problems may occur when operating Chinese data. From this perspective, Navicat supports Chinese characters and Unicode, no matter whether it is input or displayed.
On the interface, Navicat uses a large graph to facilitate intuition, functions include connection management, user management, data tables, views, pre-stored programs, queries, reports, backups, scheduling, and batch processing, the menu below provides options to enable viewing, design, add, delete, or specific features as the features differ. Interface Design is similar to Access design of database objects. It simplifies database management for beginners and accelerates database management through graphic interfaces for advanced users. This product also provides a text Console interface, which allows users to store, load, copy, paste and clear operation results, and increase management elasticity.
When operating on a data table, the system filter wizard can help users create query statements step by clicking.
Supports 18 data formats and batch schedule management
The online functions of Navicat and MySQL provide automatic reconnection upon renewal. You can also customize the number of seconds for reconnection during renewal and use SSL verification. In addition, the product also supports SSH and HTTP channels, and login through proxy servers.
Data can be imported through ODBC for export/import. More than 18 common data formats are supported, such as Access, Excel, XML, PDF, and TXT. On database backup, you can use the schedule function to back up and restore data. In addition to synchronizing data, you can also synchronize the data table structure. You can intuitively complete the synchronization task by dragging the mouse.
The report function of Navicat provides three-column editing screens: Top, end, and detailed data. Users can organize the required data through the genie or query designer to calculate, sort, or edit groups, then you can pull the required fields from the report screen to orchestrate the report screen. The report also supports 12 common 3D charts, such as bars, circles, and bubble charts, to present visual data. You can also embed subreports into reports to enrich the presentation of report data. You can create a report archive from the command line and use the compression format to reduce the space required for backup.
In terms of version support, Navicat supports MySQL 3.21 and later versions. Therefore, the system supports viewing tables, triggers, and pre-stored programs that are only added in MySQL 5.0. In terms of database server security and monitoring, you can manage users and permissions in large quantities, and monitor the program list, server variables, and server status.
(