Navicat Blog

Database Structure Synchronization using Navicat 15 Mar 11, 2020 by Robert Gravelle

Perform an Internet search for "database synchronization" and you're likely to receive a lot of information on synchronizing database data. Meanwhile, instructions on synchronizing database schema structure is less prevalent. There is an inherent risk of destroying existing data that comes with altering the database structure. For that reason, you have to be extra careful when doing so.

Navicat can be a tremendous ally in synchronizing database structures. In today's blog, we'll learn how to use Navicat Premium 15's Structure Synchronization wizard to update one database's schema structure to match that of another.

The NULL Value and its Purpose in Relational Database Systems Mar 3, 2020 by Robert Gravelle

In databases, the NULL value is one that has a very particular meaning. Thus, it is important to understand that a NULL value is different than a zero value or a field that contains spaces. In today's blog, we'll explore what the NULL value means and how to work with NULLs in Navicat Premium.

Choosing Between VARCHAR and TEXT in MySQL Feb 19, 2020 by Robert Gravelle

One of the changes in MySQL version 5.0.3 included an increase to the maximum length of VARCHAR fields from 255 to 65,535 characters. That made the VARCHAR type more similar to TEXT than ever before. For those of us who design database tables, choosing between VARCHAR and TEXT now became more challenging as a result. In today's blog, we'll outline the key differences between the two and layout the factors to consider when deciding which data type to go with.

Eliminating Repeating Groups In Your Database Tables Feb 13, 2020 by Robert Gravelle

A repeating group is a series of fields/attributes that are repeated throughout a database table. It is a common problem faced by organizations both large and small, one that can have several ramifications. For example, the same set of information being present in different areas can cause data redundancy and data inconsistency. Moreover, all of this repeating data can eat up a lot of valuable disk space and take a long of time to search through. The problem of repeating groups can be manageable in small organizations, but for larger organizations, whom must manage huge volumes of information, repeating groups can become a nightmare to deal with.

In today's blog, we'll learn how to identify repeating groups both during design time and in existing databases, as well as how to fix them. Since repeating groups are a phenomenon that can affect any relational database, we'll use Navicat Premium as our database development tool.

Listing Records Based On Averages Feb 5, 2020 by Robert Gravelle

ANSI SQL includes several aggregate functions, which allow you to perform a calculation on a set of values to return their result as a single value. These include Count(), Min(), Max(), Sum() and AVG(), and others. By default, aggregate functions apply to all rows, but you can narrow down the field by applying a WHERE clause to the SELECT statement. Moreover, you can conditionally select certain rows using a few more techniques that we'll explore here today using Navicat Premium. These include the use of a CASE statement as well as the GROUP BY clause. We'll apply these techniques on the AVG() function, but they will work equally well with all aggregate functions.

Navicat Blogs
Feed Entries
Blog Archives