Close
  • Blog
  • About
×
×
  • Blog
  • About
Menu & Search
Peter Whyte DBA Blog
Category

MySQL


May 5, 2022
MySQL
PostgreSQL
RedShift
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.

Read More
SQL Scripts Feature
September 21, 2020
MySQL
PostgreSQL
RedShift
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.

Read More
July 15, 2020
MySQL
SQL Server
Windows
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.

Read More
Creating MySQL Databases and Tables
October 8, 2019
Linux
MySQL
Windows
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.

Read More
Installing MySQL on Windows
October 3, 2019
MySQL
Windows
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.

Read More

Blog Menu

  • Homepage
  • Projects
  • Notes
  • Archives

Categories

  • AWS (3)
  • Linux (21)
  • MySQL (5)
  • PostgreSQL (7)
  • PowerShell (32)
  • RedShift (6)
  • Scripts (1)
  • SQL Server (54)
  • Windows (40)
  • WordPress (5)

Tags

Certificates & Encryption (3) CSV Files (3) Database Admin (35) Database Backups (5) Data Types (2) Deleting Data (2) Error Messages (4) Exporting Data (1) Featured (6) Git (7) Importing Data (1) Installing SQL Server (8) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (7) Restoring Databases (4) SQL Server Agent (3) SQL Server ETL (2) SQL Server Management Studio (9) SQL Server Processes (4) SQL Server Scripts (2) SQL Tips (2) Windows Admin (9) WordPress Tutorials (2) WSL (10)