Changing Data - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 87

the decision to delete must be made while examining a group of rows—there are
checkboxes beside rows in Table view mode:
These are used with the With selected X-shaped icon. A confirmation screen appears
listing all the rows that are about to be deleted. It is also possible to click anywhere
on the row's data to activate the corresponding checkbox.
Deleting All the Rows in a Table
To completely erase all the rows in a table (leaving its structure intact), we go to the
Database view and click on the database name in the left panel. We then click on the
trash can icon located on the same line as the table we want to empty:
We get a message confirming the TRUNCATE statement (the MySQL statement used to
quickly empty a table). For our exercise, we won't delete this precious data!
Emptying a table can also be done in Table view with the Empty link located on the
top menu: