Navicat Blog

The Purpose of WHERE 1=1 in SQL Statements Nov 8, 2021 by Robert Gravelle

Have you ever seen a WHERE 1=1 condition in a SELECT query. I have, within many different queries and across many SQL engines. The condition obviously means WHERE TRUE, so it's just returning the same query result as it would without the WHERE clause. Also, since the query optimizer would almost certainly remove it, there's no impact on query execution time. So, what is the purpose of the WHERE 1=1? That is the question that we're going to answer here today!

What Is SQLite and How Does It Differ from MySQL? Nov 2, 2021 by Robert Gravelle

SQLite and MySQL are equally popular open source Relational Database Management Systems (RDBMS). Both are fast, cross-platform, robust, and feature-rich. Yet, beyond these similarities, the two databases are dissimilar in several important respects. Since you are probably more familiar with MySQL, this tutorial will list SQLite's most important features, as well as dissimilitudes to MySQL, all with the goal of steering you towards the product that will best suit your needs.

Null Values and the SQL Count() Function Oct 25, 2021 by Robert Gravelle

Back in March of 2020, the The NULL Value and its Purpose in Relational Database Systems article presented the NULL value and its special meaning in relational databases. That article also described how to allow NULLs in your database tables and how to reference them in queries. In today's blog, we'll learn how to combine NULLs with the SQL Count() function to achieve a variety of objectives.

Understanding SQL Server CROSS APPLY and OUTER APPLY Queries - Part 2 Oct 19, 2021 by Robert Gravelle

CROSS APPLY and OUTER APPLY Examples

Last blog introduced the APPLY operator and covered how it differs from regular JOINs. In today's follow-up, we'll compare the performance of APPLY to that of an INNER JOIN as well as learn how to use APPLY with table valued functions.

Navicat 16 Preview Oct 11, 2021 by Robert Gravelle

Navicat 15 was released with much fanfare back in November of 2019. It came packed with many new features and improvements, most notably in data transfers, the SQL Builder, and modeling. It also added Data Visualization, Dark Mode and native Linux support. Almost two years later to the day, its time to announce the upcoming release of Navicat 16! It's currently downloadable in Beta mode, with the official release to be announced shortly. While we're waiting for that, this blog will outline some of the most note-worthy features and improvements.

Navicat Blogs
Feed Entries
Blog Archives
Share