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

Deleting Data
phpMyAdmin's interface enables us to delete the following:

•
•
•
•

Single rows of data
Multiple rows of a table
All the rows in a table
All the rows in multiple tables

Deleting a Single Row
We can use the small X-shaped icon beside each row to delete the row. If the value
of $cfg['Confirm'] is set to TRUE , every MySQL DELETE statement has to be
confirmed before execution. This is the default, since it might not be prudent to allow
a row to be deleted with just one click!

The form of the confirmation varies depending on the browser's ability to execute
JavaScript. A JavaScript-based confirmation popup would look like the following
screenshot:

If JavaScript has been disabled in our browser, a distinct panel appears:

The actual DELETE statement will use whatever information is best to ensure the
deletion of only the intended row. In our case, a primary key had been defined and
was used in the WHERE clause. In the absence of a primary key, a longer WHERE clause