• Welcome to Navicat MySQL
• System Requirements
• Feature Matrix
• Registration
• Installation
• Upgrade
• License Agreement

• Getting Started
• Installing MySQL for Windows
• Localhost Connection Settings
• Remote Connection Settings
• First time started
• Working with databases
• Working with databases objects
• Using Navigation Pane
• Using connection popup menu
• Using database popup menu
• Using object popup menu
• Virtual Grouping

• Connection Settings
• General Settings
• SSH Settings
• Benefit of SSH Tunneling
• Password Authentication
• Publich Key Authentication
• HTTP Settings
• Uploading the Tunneling Script
• Setting up HTTP Tunnel
• SSL Settings
• Installation of OpenSSL and MySQL
• Setting up SSL Certificate for MySQL
• Setting up Client Certificate for Navicat
• Advanced Settings
• Database Management
• Setting Advanced Database Properties

• Database Object Management
• Tables
• Table Designer
• Fields
• Setting Field Name and Data Type
• Setting Field Size and Decimals
• Setting Field Flags
• Setting Other Field Properties
• Indexes
• Settng Index Name and Index Type
• Setting Single- and Multi- Field Indexes
• Foreign Keys
• Setting Foreign Key Name and Table Fields
• Setting On Delete and On Update Actions
• Triggers
• Setting Trigger Name, Time and Statement
• Setting Trigger Event
• Options
• Setting Table Properties
• Setting Auto Increment and Table Flags
• Comment
• Table Viewer
• Data View
• Grid View
• Using Navigation Bar
• Limit Record Setting
• Editing Records
• Editing Records with Special Handling
• Editings Records with Foreign Key
• Copying/Pasting Data from/into Navicat
• Sorting and Finding Records
• Filtering Records
• Manipulating Raw Data
• Formatting Table Grid
• Form View
• Text/Blob View
• Viewing/Editing Text field as Memo
• Viewing/Editing Text/Blob field as Hexadecimal
• Viewing/Editing Blob field as Graphical Image
• Filter Wizard
• Adding New Filter Condition
• Setting Filter Criteria
• Setting Filter Operator
• Setting Filter Criteria Values
• Setting Filter Group
• Applying Filter Conditions
• Views
• View Designer
• Working with Visual Builder
• Editing SQL Definition
• Setting Advanced View Properties
• View Viewer
• Stored Procedures/Functions
• Stored Procedure Designer
• Editing Stored Procedure/Function Definition
• Setting Advanced Stored Procedure/Function Properties
• Editing Stored Procedure/Function Comment
• Viewing Stored Procedure/Function Result
• Events
• Event Designer
• Editing Event Definition
• Setting Advanced Event Properties
• Editing Event Comment