ItecSoftware Logo

Cross deleting records from multiple tables in mysql

mysql join delete

I’ve been asked many times how to do a MySQL join delete, that is delete records in multiple tables joined in MySQL. Here are three of methods that should get anyone started.

As always, create a backup before updating or deleting records.

Simple Inner Join Delete Method

The simple inner join method uses commas with an implicit inner join like in the example below. Here we’re using an items and price table, where each table has an itemId field which is what we ...

read more

Listed in MySQL

Tags: join delete, multiple delete, MySQL