Listing Records Based On Averages

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()...

Navicat Premium named “Best Database Administration Solution” by Database Trends and Applications Magazine

Navicat introduces cloud solution for team collaboration

Language | Navicat

Please choose your language. English 简体中文 繁體中文 日本語 Polski Español Français Deutsch 한국어 Русский Italiano Português

Demo Video 2 Navicat Monitor test

Demo Video 2 Description - abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc

Demo Video 2 Navicat Monitor ABC

Demo Video 2 Description - abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc

Demo Video 1 Navicat test

Demo Video 1 Description - abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc

newsletter-subscribe-success

Congratulations Thank you for subscribing to the Navicat Newsletter! Your email has been successfully verified. We look forward to keeping you up to date on Navicat News.

Red Herring Awards Premiumsoft Cybtertech Limited for The 2008 Red Herring Asia America 100

very happy with the quality of the companies we selected as finalists." PremiumSoft CyberTech Limited’s flagship product, Navicat, is a database administration tool for MySQL, Oracle and PostgreSQL. It reduces the workload of database administrators and...

Navigation Pane Tips and Tricks Part 2: Virtual Grouping and Connection Colouring

May 23, 2018 by Robert Gravelle The Virtual Group feature provides a mechanism for logical grouping of the Navigation Pane's database objects by category, so that all objects are more effectively organized. It can be applied to many different object...

Specifying Collation in MongoDB (Part 2)

Gravelle In this series on Collation support in MongoDB, we've been learning how to specify collation in MongoDB using the Navicat for MongoDB GUI administration and development tool. Part I provided a brief introduction to the concept of collation,...

Sorting Documents in MongoDB

Oct 18, 2018 by Robert Gravelle Sorting a list of English words is simple enough because they rely on alphabetical ordering. Sorting a set of German, or French words, with all of their accents, or Chinese with their different characters is a lot...

Get a Health and Performance Overview of All your Instances in One Place!

Jan 8, 2019 by Robert Gravelle Navicat Monitor for MySQL/MariaDB's starting screen is the Overview Dashboard. It's a one-stop shop of the real-time analytics for the health and performance of all your instances. Since the introduction of Compact View...

Understanding Stored Procedures and Functions in Relational Databases

Apr 9, 2019 by Robert Gravelle Most relational databases - including MySQL, MariaDB, and SQL Server - support stored procedures and functions. Stored procedures and functions are actually very similar, and can in fact be utilized to accomplish the same...

How the MySQL 8 Performance Schema Helps Diagnose Query Deadlocks

of our MySQL instances. Just how to do that will be the topic of today's blog. Just like last time, we'll be using Navicat Premium to demo the various queries.

How to Tell when it's Time to Rebuild Indexes in Oracle

How to Tell when it's Time to Rebuild Indexes in Oracle Jan 15, 2020 by Robert Gravelle Every so often, we need to rebuild indexes in Oracle, because indexes become fragmented over time. This causes their performance - and by extension - that of your...

Is the Database or Application the Best Place for a Custom Function?

May 6, 2020 by Robert Gravelle Deciding whether do create a function in the database or in application code can be a daunting one. All-too-often, you don't realize that you've made the wrong choice until it's a big hassle to make an about-face. Worse...

newsletter

Subscribe to Navicat Newsletter Thank you for signing up! You will receive an email confirmation of your subscription shortly. Go to your inbox and verify your email address.

Unsubscribe Success

You are now unsubscribed We're sorry to see you go. You have now successfully unsubscribed from navicat.com’s email newsletter. You will no longer receive the newsletter. If you change your mind and would like to re-subscribe, simply enter your email...

MySQL 8 Component Architecture and Error Logging

April 24, 2018 by Robert Gravelle One of the numerous significant changes to MySQL Server for version 8 includes a new component-based infrastructure. That will make the architecture more modular while allowing users to extend server capabilities...