WordPress: Delete all revisions in SQL

Revisions are good, but they consume database space. A little cleanup is necessary from time to time.

DELETE a,b,c FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'

Reproduce this customization today

The principle of the hook remains useful, but the administration screens and WordPress APIs have evolved since the publication. Test the code in a staging environment with the exact version of the site's core, theme, and plugins.

• Save the files and the database before making any changes.
• Control user capabilities, nonces, input validation, and output escaping.
• Place customizations in a dedicated plugin or a child theme to preserve updates.

Reference: official WordPress plugin development manual.