Databases Reference
In-Depth Information
In the Database view, we can delete a specific table by using the X-shaped icon for
that table. The same mechanism also exists for deleting more that one table (with the
drop-down menu and the
Drop
action).
The
Empty
and
Drop
actions are marked in red to better
indicate the inherent danger of these actions on data.
Deleting Databases
We can delete a whole database - including all its tables - using the
Drop
link in
Database view:
By default,
$cfg['AllowUserDropDatabase']
is set to
FALSE
, so this link is hidden
to unprivileged users until this setting is manually changed to
TRUE
.
To help us think twice, a special message appears before a database is deleted:
You are
about to DESTROY a complete database!
The database
mysql
containing all user and privilege
definitions is so important that the Drop button is
deactivated for this database, even for administrators.
Summary
In this chapter, we examined concepts like editing data, including the null field and
using the
Tab
key, applying a function to a value, duplicating rows of data, and
deleting data, tables, and databases.
Search WWH ::
Custom Search