Why Use WHERE 1=2 in SQL
Some time ago I wrote a 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 would anyone use WHERE 1=1 in their queries? And what does it do?The WHERE 1=1 condition means WHERE TRUE.
Creating a Linked Server with a MySQL Database
This is my 3rd Linked Server demo post, and this time it’s to a MySQL database.Noteworthy weblinks: # My Linked Server Blog Posts.# Microsoft Docs – Linked Servers.
How to Create MySQL Databases & Tables
This blog post is a guide on how to create databases and tables in MySQL, from a Windows and Linux computer.
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.
