WordPress Code Snippets

A fresh mix of code snippets and tutorials

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):

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

Show Support

Like our new Facebook Page to show support!