Table and Database Operations - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 151

Appending Data to a Table
The Copy dialog may also be used to append (add) data from one table to another.
Both tables must have the same structure. This operation is achieved by entering the
table to which we want to copy the data of the current table and choosing Data only .
For example, we would want to append data when book data comes from various
sources (various publishers), is stored in more than one table, and we want to
aggregate all the data to one place without using the MRG_MyISAM storage engine.
Multi-Table Operations
In the Database view, there is a checkbox next to each table name and a drop-down
menu under the table list. This enables us to quickly choose some tables and perform
an operation on all those tables at once. Here we select the books-copy and the
topics tables, and choose the Check operation for these tables.
We could also quickly select or deselect all the checkboxes with Check All /
Uncheck All .
Repairing an "in use" Table
The multi-table mode is the only method (unless we know the exact SQL query to
type) for repairing a corrupted table. Such tables may be shown with the in use flag
in the database list. Users seeking help in the support forums for phpMyAdmin often
receive this tip from experienced phpMyAdmin users.