Quick Start
Connect to MySQL
Databases
Tables
Adding Fields and Choosing Data Types
Customising Fields
Primary Keys and Indexes
Filter Wizard
Foreign Keys
Import/Export
Queries
Visual Query Builder
Stored Procedure
Data
Manage Users
Backup
Data Transfer
Schedule
Server Monitor
Maintaining your databases/tables
  Working with Data
 

The Table Window allows you to edit, add, delete and sort the data in a table. The Table Window also provides edit controls for editing blob data.

Filter Records

Please visit Filter Wizard for details.

Limit records

  • Click Previous page button to view the previous set of records.
  • Click Next page button to view the next set of records.
  • To edit the number of records per page, click Preferences in the Navicat Menu. Edit the Number of row per page.

Sort records

You can sort your records on any combination of fields in Navicat's Table Window.

Click the field header to sort the record in ascending by this field. Click again the field header to sort the record in descending. Click one more time to remove the sorting

Import image into database

How to import image into database

  • In Table View window, select the blob field
  • Click button
  • To insert or update data in the field, click to open the Open File dialog box and then choose a file.
  • To get the data from the field, click to save the data into the file.
  • To clear the data in the field, click .