DELETE FROM wp_posts WHERE post_type = "revision";
-- where wp_posts is your WordPress table for posts