Delete all post revisions from the database

DELETE p, tr, pm
  FROM wp_posts p
  LEFT JOIN wp_term_relationships tr ON tr.object_id = p.ID
  LEFT JOIN wp_postmeta pm          ON pm.post_id   = p.ID
 WHERE p.post_type = 'revision';