Data Viewer
Better view for your data
We think you will particularly appreciate the improvement for highlighting the selected row and active cell. You can now easier to see your current place in Grid View.

We’ve improved the data alignment in Grid View. Previously, this made it difficult to view data between number column and text column, but now Navicat handles this situation well.

General
Connection tree
- Pressing Ctrl+F in connection tree will now open the Search box in tree. It activated another Search box before.
- Adding shortcut in submenu to have quick access to create a new connection profile.

Part of knowing your business is tracking sales metrics such as units sold and identifying your best customers. To that end, you'll probably want to begin with fetching data about customers who've made the most purchases throughout the month, quarter, year, or other time period. This data will allow you to analyze their buying patterns and identify trends. This blog will present a few sample queries to do that by combining the mighty Count() function with the GROUP BY and HAVING clauses.
Having to select only odd or even rows from a table sounds like something that you'd never have to do, that is until you do. A quick Google search confirms that it's something that is done often enough, but, with few database practitioners knowing how, they invariably turn to online database communities in search of answers. As a reader of this blog, you can save yourself the trouble of scouring database forums for a solution, as we'll set the record straight right here today.
Supported Platforms and Databases, Plus SQL Editing
In this three part series, we've been comparing HeidiSQL, a free database client, with Navicat Premium. So far we've done a quick visual comparison and looked at both tools' pros and cons. In this final instalment, we'll be examining specific features, such as supported platforms and databases, SQL Editing, and more!
- 2022 (1)
- 2021 (1)
- December (1)
- November (1)
- October (1)
- September (1)
- August (1)
- July (1)
- June (1)
- Get the Maximum Value across Columns
- Introduction to Inverse Indexes
- Object Locking in Relational Database Transactions - Part 3
- Object Locking in Relational Database Transactions - Part 2
- Object Locking in Relational Database Transactions
- DBeaver vs Navicat - Part 2
- DBeaver vs Navicat: A Database Tools Showdown
- May (1)
- April (1)
- March (1)
- February (1)
- January (1)
- 2020 (1)
- 2019 (1)
- December (1)
- October (1)
- September (1)
- August (1)
- July (1)
- June (1)
- May (1)
- The Between Operator
- Some SELECT Queries You Must Know
- Diagnose Bottlenecks and/or Deadlocks in MySQL 8 using Navicat Monitor
- How the MySQL 8 Performance Schema Helps Diagnose Query Deadlocks
- How the MySQL 8 Performance Schema Helps Diagnose Query Deadlocks (2)
- How the MySQL 8 Performance Schema Helps Diagnose Query Deadlocks (3)
- April (1)
- March (1)
- February (1)
- January (1)
- 2018 (1)
- 2017 (1)
-
Support
-
About Us