Close
  • Blog
  • About
×
×
  • Blog
  • About
Menu & Search
MSSQL DBA Blog
Category

MySQL

MySQL Blog Archives, by Peter Whyte (SQL Server Database Admin). Includes MySQL posts from a SQL Server DBA's perspective!


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

Read More
WHERE 1=1
September 21, 2020
MySQL
Postgres
RedShift
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.

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

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

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
Peter Whyte DBA

Peter Whyte

Blog Menu

  • Homepage
  • MSSQL DBA Blog
  • SSMS Tips
  • SQL Notes & Links
  • DBA Blog Archives
  • WSL Windows Tips
  • Projects

Categories

  • AWS (5)
  • Linux (34)
  • MySQL (5)
  • Postgres (7)
  • PowerShell (48)
  • RedShift (7)
  • SQL Server (78)
  • Windows (64)
  • WordPress (2)

Tags

Active Directory (AD) (4) AWS CLI (3) CDC (2) Certificates & Encryption (3) Change Data Capture (2) CSV Files (4) Database Admin (54) Database Backups (10) Data Types (2) Deleting Data (2) Error Messages (4) Featured (4) Git (11) Git Commands (4) Git Log (3) Installing SQL Server (10) Linked Servers (3) Linux Admin (2) Measuring Databases (9) MSSQL SPIDs (3) NetFirewallProfile (3) New-Item PowerShell (2) PowerShell Create Folder (2) PowerShell Delete Files (2) PowerShell ForEach (2) PowerShell Tips (20) PowerShell Version (2) Restoring Databases (7) SQL Server Agent (4) SQL Server ETL (2) SQL Server Management Studio (SSMS) (14) SQL Server Processes (6) SQL Server Scripts (3) SQL Tips (19) SSH (2) SSMS Tips (9) Temp DB (2) Windows Admin (21) Windows Firewall (4) WordPress Tutorials (2) WSL (22) WSL1 (4) WSL2 (4) WSL Ubuntu (6) WSL Version (4)