MySQL commands to delete spam WordPress comments & commentmeta

delete-spam-comment.sql

delete from wp_comments where comment_approved='spam';
delete from wp_commentmeta where comment_id not in (select comment_id from wp_comments);
delete from wp_commentmeta where meta_key like '%akismet%';