Summary
This chapter examined data-changing concepts, such as:
Editing data
Including the
NULL
column and using the Tab keyApplying a function to a value
Duplicating rows of data
Deleting data, tables, and databases
We also got an overview of structure-changing techniques such as:
How to add columns, including special column types such as TEXT, BLOB, ENUM, and SET
How to use a calendar pop up for DATE, DATETIME, and TIMESTAMP column types
How to upload binary data into a BLOB column
How to manage indexes (multi-column and full-text), and get feedback from MySQL about which indexes are used in a specific query
In the next chapter, we will learn how to export a table's structure and data for backup purposes, or to use as a gateway to another application.