Why Use WHERE 1=2 in SQL
Some time ago I wrote short blog post on why use WHERE 1=1 in SQL. This time it’s why use WHERE 1=2, but really this can be WHERE 1=9 or anything that isn’t a 1, we just want the false statement.
Why use WHERE 1=1 in SQL Queries
A common SQL question is, why does anyone use WHERE 1=1 in their queries? And what does it do? The condition means WHERE TRUE, so it’s just bringing back the same query result as it would without.
Creating a Linked Server with a MySQL Database
This is my 3rd Linked Server post, and this time it’s to a MySQL database. Noteworthy weblinks: # My Linked Server Blog Posts.# Microsoft Docs – Linked Servers.
Creating MySQL Databases & Tables (with added tips)
This is a post on creating databases/tables in MySQL on both Windows and Linux, with added tips to help with general usage.
Installing MySQL 8.0 on Windows
A simple run-through of installing MySQL Community Server 8.0, including MySQL Workbench on Windows. Don’t forget to checkout the MySQL Installation documentation, and here’s a link to prerequisites.
