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.
Changing Table Structures
This chapter explores editing table definitions and using special column types.
When developing an application, requirements often change because of new or
modified needs. Developers must accommodate these changes through judicious
table-structure editing.
Adding a Field
Suppose that we need a new field to store a book's language and, that by default, the
books on which we keep data are written in English. We decide that the field will be
called language and will contain a code composed of two characters (en by default).
In the Structure sub-page of the Table view for the book table, we can find the Add
field dialog.
Pages:
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111