Delete all account that didn't login for 1 week

[PewN]

is there any command on sql that you can delete all account's that didn't login for 1 week? ex. i didn't online my account for 1 week and 2 days my account will automatically delete when i execute the command on sql.

 

but if i didn't online my account for 4 days my will not be deleted.
 

 

thanks 

[Patskie]

Let's try this : 

DELETE FROM `login` WHERE DATEDIFF(NOW(), `lastlogin`) > 6;

I don't have responsibilities if something went wrong. Please do a backup before you do something

[Brave]

Patskie i think it would work but trojan it is not a good idea to delete accounts within 7 days of not loging in

[Patskie]

And i think i just only delete the account not the whole account ( including characters )