home
previous
next
Welcome to Navicat MySQL
Welcome to Navicat MySQL
System Requirements
Feature Matrix
Registration
Installation
Upgrade
License Agreement
Getting Started
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
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
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
Queries
Queries
Query Builder
Working with Diagram Area
Setting Field Association
Setting Output Fields
Setting Criteria
Setting Grouping Criteria
Setting Sorting Criteria
Setting Limit Criteria
Query Editor
Working with Code-Completion
Query Results
Query Explain
Query Parameters
Data Management Tools
Data Management Tools
Import Wizard
Setting Import File Format (Step 1)
Setting Source File Name (Step 2)
Importing ODBC in Step 2
Importing Oracle Data (Step 2)
Importing MSSQL Data (Step 2)
Setting Additional Options for Specific Table Type
Setting Delimiter (Step 3) - TXT, XML
Setting Data Format (Step 4) - TXT, XML, Excel, HTML
Setting Target Table (Step 5)
Adjusting Field Structures and Mapping Fields (Step 6)
Selecting Import Mode (Sep 7)
Saving and Confirming Importing (Step 8)
Export Wizard
Setting Export File Format
Setting Destination File Name and Encoding
Selecting Fields for Export
Setting Data Format
Saving and Confirming Export
Data Transfer
General Settings
Advanced Settings
Message Log
Data Synchronization
General Settings
Advanced Settings
Message Log
Structure Synchronization
General Settings
Advanced Settings
Message Log
Backup/Restore
Backup
General Settings
Advanced Settings
Message Log
Backup by Dumping SQL File
Restore
General Settings
Object Selection
Advanced Settings
Message Log
Restore by Execute Batch File
Extract SQL
Batch Job/Schedule
General Settings
Settings Report Printing
Advanced Settings (E-mail Notification)
Message Log
MySQL Console
Example of Using Console
Print Database/Table Structure
Log Files
Report Management Tools
Report Management Tools
Report Builder Manual
The Basics
Report Wizard
Report Toolbars
Query Wizard
Query Designer
Dialogs
Tutorial on Creating Different Types of Reports
Simple Report
Cover Page
Simple Table Listing
Invoice
Order Summary Report
Detailed Order Summary
Sales Statistics
Crosstab Report
Mailing Label
Form Letter
Photo Album
Server Security Management
Server Security Management
Privileges Provided by MySQL
User Editor
Setting Advanced User Properties
Setting User SSL Properties
Setting Global Privileges
Setting Database Specific Privileges
Setting Table Specific Privileges
Setting Column Specific Privileges
Stored Procedure Specific Privileges
MySQL Maintenance Tasks
MySQL Maintenance Tasks
Analyze Tables
Check Tables
Optimize Tables
Repair Tables
Server Monitor
Process List
Variables
Status
Flush
Options
Options
General Options
Docking Options
Code Insight Options
Appearance Options
Color Options
Main Window Options
Detail View Options
Data/Grid Options
Display Format Options
Miscellaneous Options
Navicat Support Center
Knowledgebase (Online)
Visual Demo (Online)
Example of Using Console
Basic MySQL query statements
show databases;
use "database_name";
show tables;
SELECT "column_names" from "table_name" [WHERE ...conditions];
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.
home
previous
