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. ...
Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.