Chapter 5
[ 91 ]
When we mark some rows with the checkboxes, we can also perform two
other actions on them: delete (see the Deleting Many Rows section in this
chapter) and export (see Chapter 7).
Editing the Next Row
Starting with version 2.6.1, sequential editing is possible on tables that have a
primary key on an integer field. Our author table meets the criteria. Let's see what
happens when we start editing the row with the id value 1:
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 to 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
??? ??? ??? ???
Changing Data
[ 92 ]
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, because 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.
Pages:
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108