Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are proceeding to MySQL DELETE. Since you are familiar with T-SQL DELETE, the goal is to make you more productive using the MySQL syntax.

There are minor differences but there’s nothing that you can’t handle. Let’s get started.

Preparing the Data

To delete any records, we first need to have them. Thus, let’s build a database in MySQL. I’m feeling nostalgic about TV series from the ’80s, so I’m going to use episodes from MacGyver and Quantum Leap for sample data. I have the final Excel file to import the data into a new database. This file has 2 sheets named Titles and Episodes. We will import them both into two tables.

#sql server #mysql #mysql delete #sql delete #t-sql