mysqlsqltwitter-follow

SQL Delete All Data

I am trying to delete all the data for users with fewer than 10 followers and more than 1000 followers. I got this query by far:

DELETE FROM Test 
WHERE Followers 
BETWEEN 1 AND 9

This query deletes the data for users under 10 followers. How do I delete users with more than 1000 followers? Can I have both queries in one.

Solution

  • The problem is that you do not DELETE * That would imply that you have to tell it which columns to DELETE from a row. You However are deleting and entire row and therefore do not have to specify *

    DELETE FROM Test 
WHERE (Followers >=1 
AND Followers <10)
OR Followers >1000