
上QQ阅读APP看书,第一时间看更新
This chapter examined data changing concepts, such as:
- Editing data
- Including the null field and using the Tab key
- Applying a function to a value
- Duplicating rows of data
- Deleting data, tables, and databases
We also saw an overview of structure-changing techniques such as:
- 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 how to get feedback from MySQL about which indexes are used in a specific query
In the next chapter, we'll learn how to export a table's structure and data for backup purposes, or to use as a gateway to another application.