MySQL - Delete Records If Exists In Another Table

micky007

Hi Guys,

I have 1 table called cleaned and another table called Failed. How do i go about deleting records from the table called cleaned if the same record exists on the table called Failed?

Both fields in the table it will be looking at is called Email.

Any help would be great.

Thanks!

micky007

I've used the following:

delete from CLEANED where Email in (select Email from FailedSMTP)

I have over 1.6 million records in the table called CLEANED and its taking a long time, is there a better way of me doing this to increase the speed?

Thanks

bradgrafelman

Is "Email" an indexed field in both tables?

micky007

bradgrafelman;10989253 wrote:
Is "Email" an indexed field in both tables?

Yes 🙂

bradgrafelman

Well in that case I'm not sure what else to do.

However, is speed really a necessity? It doesn't seem like this is a mission-critical process or one that will interact with your site's visitors, so why not let the query run in the background and take however long it needs?