Products
Support
Partners
About Us
Products
Support
Partners
About Us
EN
Search
GO
About Us
About Us
Blog
Press
Awards
Our Customers
Navicat Blog
32
33
34
35
36
37
38
39
40
41
Navicat Blogs
Feed Entries
Blog Archives
2022 (
1
)
August (
1
)
Choosing a Primary Key - Part 1
Exploring Some Prevalent Stored Procedure Myths
What's New in Navicat 16.1 - Part 4
July (
1
)
Are Stored Procedures an Outdated Tool?
What's New in Navicat 16.1 - Part 3
What's New in Navicat 16.1 - Part 2
What's New in Navicat 16.1 - Part 1
Find Customers Who Have Purchased More Than n Items Within a Given Timeframe
Selecting Odd or Even Numbered Rows From a Table
June (
1
)
Exporting MySQL Tables to CSV
How to Test Insert and Update Statements before Executing Them
May (
1
)
Nested Joins Explained
Benefits of Third-party Database Management Tools
Some Top SQL Query Mistakes - Part 5
Some Top SQL Query Mistakes - Part 4
Some Top SQL Query Mistakes - Part 3
Predicates in SQL
April (
1
)
Some Top SQL Query Mistakes - Part 2
Some Top SQL Query Mistakes - Part 1
Working with Dates and Times in MySQL - Part 5
March (
1
)
Working with Dates and Times in MySQL - Part 4
Working with Dates and Times in MySQL - Part 3:
Working with Dates and Times in MySQL - Part 2
February (
1
)
Working with Dates and Times in MySQL - Part 1
Some Useful MySQL Numeric Functions
Writing Exclusive OR Conditions in Relational Databases
Creating a Test Database with Navicat 16
January (
1
)
A Virtual Tour of the New Standalone Navicat Charts Creator
Calculating Percentage of Total Rows In SQL
Navicat 16 Improvements that Maximize Productivity
2021 (
1
)
December (
1
)
Present Your Data More Effectively with Navicat 16
Improved Collaboration in Navicat 16
Generating Test Data in Navicat 16
Storing Ternary Data In MySQL and PostgreSQL
The Perils of Testing SQL in Production
November (
1
)
Unicode and Non-Unicode String Data Types in SQL Server
The Purpose of WHERE 1=1 in SQL Statements
What Is SQLite and How Does It Differ from MySQL?
October (
1
)
Null Values and the SQL Count() Function
Understanding SQL Server CROSS APPLY and OUTER APPLY Queries - Part 2
Navicat 16 Preview
September (
1
)
Understanding SQL Server CROSS APPLY and OUTER APPLY Queries - Part 1
Overview of RDBMS Index Types
Changing a Column's Data Type In Relational Databases
Floating Point Rounding Errors in MySQL
August (
1
)
Working With the MySQL Slow Query Log
Identifying Long Running Queries
The Impact of Database Indexes On Write Operations
The Downside of Database Indexing
July (
1
)
What Is Database Monitoring and Why Is It Useful?
How to Partition a MySQL Table Using Navicat
Data Type Conversion in MySQL 8
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
May (
1
)
Using the SQL COUNT() Function with GROUP BY
Important SQL Server Functions - Miscellaneous Functions
Important SQL Server Functions - Date Functions
Important SQL Server Functions - Numeric Functions
Important SQL Server Functions - String Utilities
Iterate over Query Result Sets Using a Cursor
April (
1
)
Copying a Table to a New Table using Pure SQL
Using Transactions in Stored Procedures to Guard against Data Inconsistencies
Understanding Database Transactions
Preventing SQL Injection at the Database Level
March (
1
)
Atomicity in Relational Databases
Using Group By and Order By in the Same Query
Calculating Daily Average Date/Time Intervals in MySQL
Querying Multiple Tables without Joins
Three Ways to Perform Bulk Inserts
February (
1
)
Joins versus Subqueries: Which Is Faster?
January (
1
)
Database Optimization: an Overview
What is a Flat File Database?
2020 (
1
)
December (
1
)
Identifying Columns with Missing Values in a Table
November (
1
)
Calculating Average Daily Counts in SQL Server
Why MySQL (Still) Tops the List of Most Popular Database Platforms
Preventing the Occurrence of Duplicate Records
October (
1
)
A Guide to Refreshing Test Data
All About ORDINAL_POSITION
What Is Ransomware and Why You Should Be Concerned
Filtering Dates by Month
Achieving Lightning Fast Query Response Time in MySQL 8
Preventing All Records from Being Deleted Within a Stored Procedure
September (
1
)
Obtaining Meta-data about Database Table Columns
Selecting the Second Highest Value from a Table
Comparing the Semantics of Null, Zero, and Empty String in Relational Databases
August (
1
)
The Many Flavors of the SQL Count() Function
Storing Formatted Fields in a Database
Applying Select Distinct to One Column Only
Splitting Query Results into Ranges
July (
1
)
Using Output Parameters in Stored Procedures
Hiding Databases From Users in MySQL
Selecting Rows That Have One Value but Not Another
June (
1
)
Using a Case Statement in a Where Clause
Troubleshooting Slow Query Execution with Navicat Monitor 2
Counting String Occurrences in SQL
May (
1
)
MySQL Default Values: Good or Bad? - Part 2: When To Use Them
MySQL Default Values: Good or Bad? - Part 1: Strict SQL Mode
Top N Queries by Group
Is the Database or Application the Best Place for a Custom Function?
April (
1
)
Managing Databases Remotely Using Navicat - Part III
Managing Databases Remotely Using Navicat - Part II
Managing Databases Remotely Using Navicat
March (
1
)
Database Structure Synchronization using Navicat 15
The NULL Value and its Purpose in Relational Database Systems
February (
1
)
Choosing Between VARCHAR and TEXT in MySQL
Eliminating Repeating Groups In Your Database Tables
Listing Records Based On Averages
January (
1
)
Selecting All But One Column In MySQL
How to Tell when it's Time to Rebuild Indexes in Oracle
Storing Images in MySQL with Navicat
2019 (
1
)
December (
1
)
Navicat Premium 15 - the Most Powerful Yet!
Perform Full-text Searches in MySQL (Part 3)
Welcome to Navicat Premium 15! Data Visualization
October (
1
)
Perform Full-text Searches in MySQL (Part 2)
Perform Full-text Searches in MySQL (Part 1)
Monitor your SQL Server Instances with Navicat Monitor
September (
1
)
Working with Cursors in MongoDB
Introducing Navicat Data Modeler 3.0!
Using the SQL CASE Statement
Navicat Data Modeler 3 Beta was released today!
August (
1
)
Validating Data using Triggers in MySQL 8
July (
1
)
Using the SQL Limit Keyword
The SQL Self JOIN
Managing Multiple Databases from a Single Application
June (
1
)
More Essential SELECT Queries for Every Database Developer's Toolkit
Connecting to Multiple Databases from a Single Tool
How to Query across Multiple Databases
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
April (
1
)
Using the MySQL Information Schema
A Few MySQL Tips and Tricks
Understanding Views in Relational Databases
Understanding Stored Procedures and Functions in Relational Databases
Performing Regular Expression Searches in MongoDB
March (
1
)
All about MongoDB's _id Field
Using Covered Queries in MongoDB
February (
1
)
Performing Database-wide Searches in Navicat Premium
Create DBRefs in MongoDB
Relationships in MongoDB
January (
1
)
Deciding between NoSQL and Traditional Relational Databases
Get a Health and Performance Overview of All your Instances in One Place!
2018 (
1
)
December (
1
)
Optimize Query Performance using the Navicat Query Analyzer (Part 2)
Optimize Query Performance using the Navicat Query Analyzer (Part 1)
Receive Notifications for MySQL/MariaDB Issues
Working with MySQL Logs (Part 3): the Slow Log
Working with MySQL Logs (Part 2): the Binary Log
November (
1
)
Working with MySQL Logs
Configure an Instance in Navicat Monitor for MySQL/MariaDB
Storing Large Files in MongoDB
New Features in Navicat Monitor 1.8
October (
1
)
Editing User Roles in Navicat for MongoDB
Introduction to User & Role Management in MongoDB
Sorting Documents in MongoDB
Specifying Collation in MongoDB (Part 2)
Specifying Collation in MongoDB (Part 1)
September (
1
)
Introduction to Views in MongoDB
Analyzing MongoDB Schemas and Data
Navicat for MongoDB Grid View Features- Expanding Array Values, Colorizing Cells, and Migrating Data (Part 2)
August (
1
)
Navicat for MongoDB Grid View Commands (Part 1)
Working with Documents in Navicat for MongoDB
MongoDB Documents Tutorial
Working with NoSQL Databases
July (
1
)
Navicat for MongoDB is Here
Schedule Database Tasks using the Navicat Event Designer (Part 5)
Starting and Stopping MySQL 8 Events (Part 4)
Scheduling MySQL 8 Events (Part 3)
Working with MySQL Events (Part 2)
June (
1
)
An Introduction to Database Events (Part 1)
Manage MySQL Users in Navicat Premium - Part 4: The Privilege Manager tool
Manage MySQL Users in Navicat Premium - Part 3: Configuring User Privileges
Manage MySQL Users in Navicat Premium - Part 2: Creating a New User
May (
1
)
Manage MySQL Users in Navicat Premium - Part 1: Securing the Root
Navigation Pane Tips and Tricks Part 2: Virtual Grouping and Connection Colouring
Navigation Pane Tips and Tricks Part 1: Managing Connections
What to Monitor on SQL Server (Part 2)
What to Monitor on SQL Server (Part 1)
April (
1
)
MySQL 8 Component Architecture and Error Logging
Disk Encryption in SQL Server
Get Row Counts from Multiple Tables and Views in MySQL (Part 3)
Getting Advanced Row Counts in MySQL (Part 2)
March (
1
)
Getting Row Counts in MySQL (part 1)
Using Navicat Code Snippets
Navicat Query Builder: Setting Grouping Criteria (Part 5)
February (
1
)
Navicat Query Builder- Working with Aggregated Output Fields (Part 4)
Determine How Much Data Has Changed Since Your Last Full Backup on SQL Server
Navicat Query Builder - Filtering Results (Part 3)
January (
1
)
Eliminating Duplicate Rows using SELECT DISTINCT in MySQL (Part 4)
Navicat Query Builder- Field Selection (Part 2)
How to Delete Duplicate Rows with Different IDs in MySQL (Part 3)
Automate Database Replication with Navicat Premium 12
Design SELECT Queries using Navicat's Query Builder (Part 1)
2017 (
1
)
December (
1
)
How to Identify Duplicates with Non-unique Keys (Part 2)
How to Spot and Delete Values with Duplicate Meaning in MySQL (Part 1)
Create a Model from a Database in Navicat
Performing Database-wide Searches in Navicat
October (
1
)
Compare two MySQL databases for any differences
Prepare to Migrate Databases to Amazon Aurora
September (
1
)
Manage your AWS Aurora databases with Navicat
How to optimize the MySQL Server
Share
Key Topics
Navicat 16 Highlights
Collaboration
What is Navicat for MongoDB
What is Navicat Data Modeler
Discover Navicat Monitor
Top 10 Reasons
Products
Navicat
Navicat Collaboration
Navicat Charts
Navicat Monitor
Navicat Data Modeler
Support
Manuals
Articles
Survey
Live Support
Account
Customer Center
Subscription Portal
Navicat Cloud
Partners
Find Resellers
Resellers
Technology Partners
Sponsorships
Navicat Academic Partner Program
About Us
Our Customers
Awards
Press
Blog
Others
Software Maintenance
Upgrades
Site Licenses
Offline Orders
Unsubscribe