Databases Reference
In-Depth Information
Summary
This chapter examined data-changing concepts, such as:
• Editing data
• Including the
NULL
column and using the
Tab
key
• Applying 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.
Search WWH ::
Custom Search