Database Reference
In-Depth Information
The form of the confirmation varies depending on the browser's ability to
execute JavaScript. A JavaScript-based confirmation pop up 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 needed 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 generated
WHERE
clause might
even prevent the correct execution of the
DELETE
operation, especially if there are
TEXT
or
BLOB
fields. This is because the HTTP transaction, used to send the query to
the web server, may be limited in length by the browser or the server. This is another
reason why defining a primary key is strongly recommended.
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:
Search WWH ::
Custom Search