CODEWITHSUNDEEP
mysqloptimizationwhere-clausesql-delete
Alexei T
Alexei T

Reputation: 708

Optimize DELETE FROM with WHERE clause

How can I optimize this query ? 

DELETE FROM item WHERE id = 1002;
DELETE FROM item WHERE id = 1003;
DELETE FROM item WHERE id = 102232;
DELETE FROM item WHERE id = 12322;

It is a way out ? 

DELETE FROM item WHERE id = 1002 OR id = 1003 OR id = 102232 OR id = 12322;

I need Expert's mind very much!

Upvotes: 0

Views: 310

Answers (1)

Michael Laffargue
Michael Laffargue

Reputation: 10294

DELETE FROM item WHERE id IN (1002,1003,102232,12322)

It's simpler but what do you mean by optimized (faster ?)

Upvotes: 2

Related Questions