Delete all records of a specific table in phpMyAdmin:
DELETE FROM `bb863_postmeta`; ALTER TABLE `bb863_postmeta` AUTO_INCREMENT = 1
Deletes all table entries and resets indexing back to 1. „Truncate tableName“ would fail on a table with key constraint defined. It will also not reindex the table AUTO_INCREMENT value.
More: https://stackoverflow.com/questions/18271951/delete-all-records-in-a-table-of-mysql-in-phpmyadmin
Tags: MySQL, phpMyAdmin
