To delete/erase/drop the autosave revisions that WordPress creates in a database table, run this SQL query:

DELETE FROM wp_posts WHERE post_type = "revision"