-- delete all revisions
DELETE FROM wp_posts WHERE post_type = "revision";

-- delete all revisions from a particular post (replace 999 with your post id)
DELETE FROM wp_posts WHERE post_type = "revision" and post_parent = 999;