Chapter 5. 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.