Truncate Database Table
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
- 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
500to whatever number