Databases Reference
In-Depth Information
Changing Data and Structure
Data is not static, it changes often. This chapter focuses on editing and deleting data
and its supporting structures—tables and databases.
The chapter is divided into two main parts. The first part covers all aspects of
changing data. First we examine how to edit data, that is, how to enter the edit mode,
how to edit more than one row at once, and how to benefit from inline editing. Next
we see how to delete rows of data and how to delete tables and databases.
The second part explains how to modify the structure of tables. We examine how to
add a column to a table; we then explore various column types such as
TEXT
,
BLOB
,
ENUM
,
DATE
, and
BIT
column types. Finally, we examine the management of indexes.
Changing data
In this section, we cover the various ways of editing and deleting data.
Entering edit mode
When we browse a table or view results from a search on any single-table
query, small icons and links appear on the left or right of each table row as shown in
the following screenshot:
Search WWH ::
Custom Search