- Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Getting Started with phpMyAdmin
- PHP and MySQL: The leading open source duo
- What is phpMyAdmin?
- Installing phpMyAdmin
- Configuring phpMyAdmin
- Installing phpMyAdmin configuration storage
- Upgrading phpMyAdmin
- Summary
- 2. Configuring Authentication and Security
- 3. Over Viewing the Interface
- 4. Creating and Browsing Tables
- 5. Changing Data and Structure
- Changing data
- Changing table structure
- Summary
- 6. Exporting Structure and Data (Backup)
- 7. Importing Structure and Data
- 8. Searching Data
- 9. Performing Table and Database Operations
- 10. Benefiting from the Relational System
- 11. Entering SQL Statements
- 12. Generating Multi-table Queries
- 13. Synchronizing Data and Supporting Replication
- Synchronizing data and structure
- Supporting MySQL replication
- Summary
- 14. Using Query Bookmarks
- 15. Documenting the System
- 16. Transforming Data using MIME
- Browsing data without transformations
- Enabling transformations
- Examples of transformations
- Summary
- 17. Supporting Features Added in MySQL 5
- 18. Tracking Changes
- 19. Administrating the MySQL Server
- A. Troubleshooting and Support
Prior to MySQL 4.1, the MySQL structure itself did not support the addition of comments to a column. Nevertheless, thanks to phpMyAdmin's metadata, we could comment on columns. However, since MySQL 4.1, native column commenting has been supported. The good news is that for any MySQL version, column commenting in phpMyAdmin is always accessed via the Structure page by editing the structure of each column. In the following example, we need to comment on three columns of the book table. Hence, we choose them and click on the pencil icon near the With selected choice.
To obtain the next panel, as seen here, we are working in vertical mode. This mode was covered in Chapter 5. We enter the comments as shown in the following screenshot, and then click on Save:
These comments appear at various places, for example, in the export file (refer to Chapter 6), on the PDF relational schema (refer to Chapter 15), and in browse mode, as shown in the following screenshot:
If we do not want the comments to appear in browse mode, we can set $cfg['ShowBrowseComments'] to FALSE. (It is TRUE by default.)
Column comments also appear as a tool tip in the Structure page, and column names are underlined with dashes. To deactivate this behavior, we can set $cfg['ShowPropertyComments'] to FALSE. (This one is also TRUE by default.)
-
No Comment