New answers tagged delete
-1
votes
MySQL DELETE statement doesn't use index although the same SELECT query does
May be you can try like this:
EXPLAIN DELETE d.* FROM data d WHERE country='Y' and category='X'
1
vote
Accepted
SELECT / DELETE rows where consecutive null value count is greater than N
To just select:
SELECT *
FROM (
SELECT *, count(*) OVER (PARTITION BY receiver, grp) AS grp_count
FROM (
SELECT *, count(recv_time) OVER (PARTITION BY receiver ORDER BY send_time) AS grp
...
- 170k
0
votes
Keep the foreign key constraint using soft delete
Using soft deletes invariably leads to more complex SQL because you're having to allow for things that exists, but that you want to treat as if they didn't.
That said, it is only one extra element on ...
- 8,118
1
vote
Keep the foreign key constraint using soft delete
You could make <primary key> plus <isdeleted> a composite unique key, and reference that in the foreign keys instead of the primary key, though this would feel a bit dirty to me. You would ...
- 31.7k
Top 50 recent answers are included