Database Reference
In-Depth Information
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—
You are about to DESTROY a complete
database!—
appears before a database is deleted.
The database
mysql
, containing all user and privilege definitions, is
highly important. Therefore, the
Drop
button is deactivated for this
database, even for administrators.
Summary
This chapter examines concepts, such as:
•
Editing data
•
Including the null field and using the
Tab
key
•
Applying a function to a value
•
Duplicating rows of data
•
The next chapter will cover another kind of change—modifications to a table's
structure. This includes:
Deleting data, tables, and databases
•
Adding columns
•
Handling special data types such as
DATE
,
ENUM
and
BIT
columns
•
Managing indexes
Search WWH ::
Custom Search