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
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
Chapter 5
[ 93 ]
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.
Pages:
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109