Get some useful tips to improve the way you use Navicat.

Windows:

Open Windows Explorer:

target connection & “Ctrl + G”

History log:

Ctrl + H

(the log will be over-written when Navicat restarts)

Open a query editor:

Ctrl + Q

Find record in a table:

Ctrl + F

Open multiple windows:

“Tools” menu > “Options” > “General” > “Allow Multiple Form Instance” & “Allow Multiple Navicat Instances” > OK

Starts import wizard:

Drag import files over and drop into the target database

Edit value:

“Tools” menu > “Server Monitor” > targeted database type > “Variable” tab > click the button next to the value/ press “Ctrl + Enter” > edit value > “OK”

(edit values directly for the variables in MySQL & Oracle servers only)

Create open table shortcut:

right click a table > “Create Open Table Shortcut…” > the table shortcut can be saved outside Navicat

Action to a query by right-drop:

Right-drop a query from Navicat to a Windows location > Copy/ Move/ Create query shortcuts

Action to a query by left-drop:

Left drop a query from Navicat to Windows location> Move query

Available batch job list:

New “Batch Job” > Navicat logo on the left panel > the data transfer & data synchronization profiles are shown on “Available Jobs” column

Enable the table hint option:

“Tools” menu > “Options…” > “Appearance” > “Main Window” > “General” > check “Show table hint” > OK > point at a table to show the hint

Show objects’ detail:

“View” menu > check “Detail”

Rearrange & specify columns:

“View” menu > “Choose Columns…”

Mac:

Open log:

Cmd – L

Find record in a table:

Cmd – F

Open multiple windows:

Menu > “Preference” > “General” tab > check “Allow opening multiple instances”

Starts import wizard:

Drag import files over and drop into the target database

Edit value:

Menu > “Tools” > “Server Monitor” > “Variables” tab > click the button next to the value > edit value > “OK”

(edit values directly for the variables in MySQL & Oracle servers only)

Open table:

Simply drag & drop the table from Navicat to the desired location

Available batch job list:

New “Batch Job” > Navicat logo on the left panel > the data transfer & data synchronization profiles are shown on “Available Jobs” column 

Enable/ disable primary key warning:

Menu > “Preferences” > “Grids” tab > check/ uncheck “Show primary key warning”

Show objects’ detail:

Menu > “View” > check “Detail”

Rearrange & specify columns:

Menu > “View” > “Customize Columns…”

Linux:

History log:

Ctrl + H

(the log will be over-written when Navicat restarts)

Open a query editor:

Ctrl + Q

Find record in a table:

Ctrl + F

Open multiple windows:

“Tools” menu > “Options” > “General” > “Allow Multiple Form Instance” & “Allow Multiple Navicat Instances” > OK

Starts import wizard:

Drag import files over and drop into the target database

Edit value:

“Tools” menu > “Server Monitor” > targeted database type > “Variable” tab > click the button next to the value/ press “Ctrl + Enter” > edit value > “OK”

(edit values directly for the variables in MySQL & Oracle servers only)

Available batch job list:

New “Batch Job” > Navicat logo on the left panel > the data transfer & data synchronization profiles are shown on “Available Jobs” column

Enable the table hint option:

“Tools” menu > “Options…” > “Appearance” > “Main Window” > “General” > check “Show table hint” > OK > point at a table to show the hint

Show objects’ detail:

“View” menu > check “Detail”

Rearrange & specify columns:

“View” menu > “Choose Columns…”

Check out our other tutorials at bit.ly/navicatyoutube.