Changing Data and Structure - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 99

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!
Deleting data, either row-by-row or by emptying a table, is
a permanent action. No recovery is then possible except by
restoring a backup.
Deleting all rows in multiple tables
A checkbox is present on the left of each table name. We can choose some tables.
Then, in the With selected menu, choose the Empty operation as shown in the
following screenshot:
Of course, this decision must not be taken lightly!
Deleting tables
Deleting a table erases the data and the table's structure. In the Database view,
we can delete a specific table by using the red Drop icon for that table. The same
mechanism also exists for deleting more than one table (with the drop-down menu
and the Drop action).