homehome previousprevious nextnext
 
Welcome to Navicat MySQL (Linux Version)
Getting Started
Connection Settings
Database Object Management
Queries
Data Management Tools
Server Security Management
MySQL Maintenance Tasks
Options
Navicat Support Center
Knowledgebase (Online)
Visual Demo (Online)
Feature Matrix

 
Windows Enterprise Edition
Windows Standard Edition
Windows Lite Edition
Mac OS X Standard Edition
Mac OS X Lite Edition
Linux Standard Edition
Linux Lite Edition
MySQL Objects Management
Supports MySQL Servers 3.21 or above.
+
+
+
+
+
+
+
Create / Drop Databases.
+
+
+
+
+
+
+
Create / Drop / Alter Tables.
+
+
+
+
+
+
+
Create / Drop Indexes.
+
+
+
+
+
+
+
Create / Drop Functions.
+
+
+
+
+
+
+
Supports all Field Types. (including Blobs)
+
+
+
+
+
+
+
Supports Foreign Key for InnoDB Tables.
+
+
+
+
+
+
+
Supports Event for MySQL 5.1.6 or above.
+
+
+
+
+
+
+
Supports Stored Procedure for MySQL 5.0 or above.
+
+
+
+
+
+
+
Supports Views for MySQL 5.0 or above.
+
+
+
+
+
+
+
Supports Triggers for MySQL 5.0.2 or above.
+
+
+
+
+
+
+
Supports BIT Data Type for MySQL 5.0.3 or above.
+
+
+
+
+
+
+
Supports VARCHAR Data Type. Value from 0 to 65,535 in 5.0.3 and later versions.
+
+
+
+
+
+
+
Supports BINARY/VARBINARY Data Type.
+
+
+
+
+
+
+
Databases Connection and Navigation
Supports Multiple MySQL Server Connections. (i.e. Local / Remote MySQL servers)
+
+
+
+
+
+
+
Supports exporting Registry Record(.reg).
+
+
+
-
-
-
-
Supports Unicode / Character Set.
+
+
+
+
+
+
+
Supports SSL Connection.
+
+
+
+
+
+
+
Supports HTTP Tunnel.
+
+
+
+
+
-
-
Supports SSH Tunnel.
+
+
+
+
+
+
+
Supports SQL-Batch Files Execution.
+
+
+
+
+
+
+
Supports Adding Custom Databases to Server Navigator.
+
+
+
+
+
+
+
Table Design and Data Editor
Form View.
+
+
-
-
-
+
-
Supports Foreign Key for InnoDB Tables.
+
+
+
+
+
+
+
Supports Foreign Key Auto-Completion.
+
+
-
+
-
+
-
Create / Drop / Alter Tables.
+
+
+
+
+
+
+
Supports all Table Types. (including Transaction-Safe Tables)
+
+
+
+
+
+
+
Supports Filter Wizard for Filtering your Tables. Save and Restore Different Filter Sets for your Tables.
+
+
-
+
-
+
-
Create / Drop Indexes or Functions.
+
+
+
+
+
+
+
Record Result Count & SQL Statement Viewing.
+
+
+
+
+
+
+
Customizable Display Formats for Integer, Float, Date, Time and Datetime Fields.
+
+
+
-
-
+
+
Customizable Limit Record for Number of Rows Per Page.
+
+
+
+
+
+
+
Duplicate Tables.
+
+
+
+
+
+
+
Empty Tables.
+
+
+
+
+
+
+
Print Table Structure.
+
+
-
+
-
+
-
SQL Processing
Visual Query Builder.
+
+
-
+
-
+
-
Visual View Builder.
+
+
-
+
-
+
-
Code-Completion for Query, View and Event.
+
+
-
-
-
+
-
Multiple SQL Editors with Syntax Highlighted.
+
+
+
+
+
+
+
Script Executing (SQL Script Editor).
+
+
+
+
+
+
+
History Log for Executed Queries.
+
+
+
+
+
+
+
SQL Monitor.
+
+
+
+
+
+
+
SQL Console.
+
+
+
+
+
-
-
Data Manipulation Tools
Data and Structural Synchronization.
+
+
-
+
-
+
-
Data Transfer.
+
+
-
+
-
+
-
Backup and Restore.
+
+
-
+
-
+
-
Import Data from ODBC.
+
+
-
-
-
-
-
Import Data from MS Access.

- Navicat supports to import multiple tables, primary keys and foreign keys from Access
+
+
-
-
-
-
-
Import Data from MS Excel.

- Navicat supports to import multiple spreadsheet from Excel
+
+
-
+
-
-
-
Import Data from several file formats : DBF, TXT, CSV, XML, etc.
+
+
-
+
-
+
-
Export Data to MS Accesl.
+
+
-
-
-
-
-
Export Data to MS Excel.
+
+
-
-
-
+
-
Export Data to different file formats: HTML, PDF, TXT, CSV, DBF, XML, etc.
+
+
-
+
-
+
-
Export Data to SQL script as INSERT statement.
+
+
+
+
+
+
+
Support Unicode.
+
+
+
+
+
+
+
BLOB Viewer / Editor with several types of viewing BLOB data.
+
+
+
+
+
+
+
Schedule for Batch Job
Schedule Backup.
+
+
-
+
-
+
-
Schedule Data Transfer.
+
+
-
+
-
+
-
Schedule Import & Export Data.
+
+
-
+
-
+
-
Schedule Data Synchronization.
+
+
-
+
-
+
-
Schedule Queries Execution.
+
+
-
+
-
+
-
Schedule Report Printing.
+
-
-
-
-
-
-
Export Report to multiple formats, PDF, Excel, HTML etc.
+
-
-
-
-
-
-
Send notification e-mail for schedule task.
+
+
-
-
-
+
-
Server Security and Monitoring
Visual User Manager for Administering Users and Privileges.
+
+
+*
+
+*
+
+*
Server Monitor. (i.e. Process List, Server Variables and Server Status)
+
+
-
+
-
+
-
Report Management Tools
Report Builder.
+
-
-
-
-
-
-
Report Viewer.
+
-
-
-
-
-
-

* For Windows Lite Edition and Mac OS X Lite Edition, the feature of Duplicate User is not available.
Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
MySQL TM is a trademark of MySQL AB in the United States and other countries.