I wanted to delete all the revisions I had for my posts in wordpress. This is how I did it:

DELETE from wp_posts
WHERE post type = 'revision';

Query OK, 94 rows affected (0.00 sec)

Yay. Simple thing.