Tag: MySQL

MySQL Cross-Over Blog Posts from an experienced Microsoft SQL Server Database Administrator. Includes guides such as creating a Linked Server to MySQL, and more.

Why Use WHERE 1=2 in SQL

May 5, 2022

In a previous blog post, I explained why WHERE 1=1 is often used in SQL queries. This time, let’s discuss WHERE 1=2 — or any condition that results in a FALSE value, such as WHERE 1=9. Essentially, the point is to use a condition that is guaranteed to…
Read More
Creating a Linked Server with a MySQL Database

July 15, 2020

This is my third Linked Server demo post, and this time, we’re connecting to a MySQL database. Here’s a simple diagram of the setup covered in this post, configuring a Linked Server to a MySQL Database: For this setup, I’ve covered it all in previous blog posts: –…
Read More
How to Create MySQL Databases & Tables

October 8, 2019

Setting up MySQL databases and tables is a foundational skill for database administrators and developers. Whether you’re using Windows, Linux, or a cloud environment, this guide is aimed to help you create databases and tables in MySQL. Topics covered: > Create a MySQL Database> The USE DATABASE Command>…
Read More
How to Install MySQL on a Windows Computer

October 3, 2019

Installing MySQL on a Windows computer is a straightforward process, however selecting the right options is key for a smooth setup. This is a simple how to for installing MySQL Community Server and MySQL Workbench on Windows. I recommend you walk through this yourself if learning MySQL and…
Read More

SQL DBA Blog

Tag: MySQL

Why Use WHERE 1=2 in SQL

Creating a Linked Server with a MySQL Database

How to Create MySQL Databases & Tables

How to Install MySQL on a Windows Computer

Categories

Tags