I just want to delete all my wordpress comments because they are making my blog very slow and people are simply spamming with their url links.
here is the solution for your problem to delete/remove comments. approved/spam/trash etc..
First loginto your database using phpmyadmin tool (ask ur hosting provider how to)..
then go to the sql query analyzer:
execute the below command to delete pending comments. delete from wp_comments WHERE comment_approved ="0"; execute the below sql query to delete all approved comments:
delete from wp_comments WHERE comment_approved ="1"; if u wanna delete all the comments:
delete from wp_comments;