Mastering phpMyAdmin 3.3.x for Effective MySQL Management
上QQ阅读APP看书,第一时间看更新

Summary

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.