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.
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.
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.
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.
This is a post on creating databases/tables in MySQL on both Windows and Linux, with added tips to help with general usage.
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.