WP-Mix

Quick SQL code snippet that enables you to truncate any MySQL database table.

Let’s say that your table name is wp_downloads. It contains thousands of rows and so you want to truncate the data to a more manageable size. To do so, execute the following SQL query (via phpMyAdmin or whatever works for you):

DELETE FROM `wp_downloads` ORDER BY `id` ASC LIMIT 500

Key points:

• Instead of DELETE you can use TRUNCATE
• ASC = ascending, means that oldest entries are deleted first
• Remember to make a backup before trying this query. Just in case.
• You can change the number of rows that are deleted by changing 500 to whatever number

Possibly Related

• Reduce the Size of the WP-ShortStat Database Table