- 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
This chapter examined data-changing concepts, such as:
- Editing data
- Including the
NULLcolumn 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.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.