Navicat Blog

Writing Exclusive OR Conditions in Relational Databases Feb 11, 2022 by Robert Gravelle

One of the key ingredients to writing effective SQL queries is the ability to articulate a wide variety of conditions using SQL syntax. One condition that gives both newbies and experienced database developers pause for thought is the Exclusive OR. Software programmers tend to be more familiar with the syntax for the Exclusive OR condition, probably because most programming languages support the XOR logical operator, whereas many databases do not.

In simple terms, the Exclusive OR condition is similar to the regular OR, except that, in the case of the Exclusive OR, only one of the compared operands may be true, and not both. In this blog, we'll learn how to express an Exclusive OR condition for a variety of databases, whether they support the XOR operator, or not.

Creating a Test Database with Navicat 16 Feb 7, 2022 by Robert Gravelle

Recently, we learned how to generate test data using Navicat 16's new Data Generation tool. It can help produce a large volume of complex testing data over multiple related tables, all guided by a multi-step wizard. In today's follow-up, we'll go through the process of creating a MySQL test database - all using Navicat 16.

A Virtual Tour of the New Standalone Navicat Charts Creator Jan 21, 2022 by Robert Gravelle

As mentioned in the recent Present Your Data More Effectively with Navicat 16 blog, Navicat 16 added some new charting features, such as support for more data sources and chart types as well as an increased focus on usability and accessibility. These improvements coincide with the release of the new standalone Navicat Charts Creator. This blog will provide a tour of the Navicat Charts Creator and demonstrate how the Navicat Charts Creator can help you to gain deeper insights from your data.

Calculating Percentage of Total Rows In SQL Jan 14, 2022 by Robert Gravelle

There are many times where you'll want to see the relative contribution of a row (or group of rows) to the total row count. In other words, what percentage of the total count a row represents. To illustrate, let's take the following table, shown in Navicat Premium 16:

fruits_table (68K)

Navicat 16 Improvements that Maximize Productivity Jan 7, 2022 by Robert Gravelle

Throughout the past several weeks, we've been looking at Navicat 16's new features. While exciting to see, one should not discount the many improvements to Navicat that enhance its already great User Interface (UI) and workflow. Hence, today's blog will focus on improvements whose aim is to maximize performance and productivity.

Navicat Blogs
Feed Entries
Blog Archives