Changing Data - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 80

will be generated based on the value of each field. The WHERE clause might even
prevent the correct execution of the DELETE operation, especially if there are TEXT or
BLOB fields, because the HTTP transaction used to send the query to the web server
may be limited in length by the browser or the server.
Deleting Many Rows
A feature added to phpMyAdmin in version 2.5.4 is the multi-row delete. Let's say
we examine a page of rows and decide that some rows have to be destroyed. Instead
of deleting them one by one with the Delete link or icon - and because sometimes
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: