In this chapter, we get an overview of:
- How to add fields, including special field types such as TEXT, BLOB, ENUM, and SET
- How to use a calendar pop up for DATE, DATETIME, and TIMESTAMP fields
- How to upload binary data into a BLOB field
- How to manage indexes (multi-field and full-text), and get feedback from MySQL about which indexes are used in a specific query
In Chapter 7, we'll learn how to export a tables structure and data for backup purposes, or to use as a gateway to another application.