Changing Data - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 89

The editing panel appears, and we can edit author number 1 . However, in the
drop-down menu, the Edit next row choice is available. If chosen, the next
author—the first one whose primary key value is greater than the current primary
key value —will be available for edit.

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!