舉報 
會員
Mastering phpMyAdmin 3.4 for Effective MySQL Management
最新章節(jié)：
Index
Thisisastep-by-stepinstructionalguidetogetyoustartedeasilywithphpMyAdminandteachyoutomanageandperformdatabasefunctionsonyourdatabase.Youwillfirstbeintroducedtotheinterfaceandthenbuildbasictablesandperformbothsimpleandadvancedfunctionsonthecreateddatabase.Thebookprogressesgraduallyandyouwillfollowitbestbyreadingitsequentially.Ifyouareadeveloper,systemadministrator,orwebdesignerwhowantstomanageMySQLdatabasesandtablesefficiently,thenthisbookisforyou.ThisbookassumesthatyouarealreadywellacquaintedwithMySQLbasics.Thisbookisamust-readforeveryseriousphpMyAdminuserwhowouldliketousethisoutstandingapplicationtoitsfullpower.
目錄(148章)
倒序
- coverpage
- Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 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
- Chapter 2. Configuring Authentication and Security
- Logging in to MySQL through phpMyAdmin
- Securing phpMyAdmin
- Summary
- Chapter 3. Over Viewing the Interface
- Over viewing panels and windows
- Customizing general settings
- Character sets and collations
- Navigation panel
- Main panel
- User preferences
- Query window
- Summary
- Chapter 4. Creating and Browsing Tables
- Creating a database
- Creating our first table
- Inserting data manually
- Browse mode
- Profiling queries
- Creating an additional table
- Summary
- Chapter 5. Changing Data and Structure
- Changing data
- Changing table structure
- Summary
- Chapter 6. Exporting Structure and Data (Backup)
- Dumps backups and exports
- Exporting a database
- Exporting a table
- Exporting selectively
- Exporting multiple databases
- Saving the export file on the server
- Memory limits
- Summary
- Chapter 7. Importing Structure and Data
- Limits for the transfer
- Importing SQL files
- Importing CSV files
- Importing other formats
- Reading files from a web server upload directory
- Displaying an upload progress bar
- Summary
- Chapter 8. Searching Data
- Single-table searches
- Performing a complete database search
- Stopping an errant query
- Summary
- Chapter 9. Performing Table and Database Operations
- Maintaining a table
- Changing table attributes
- Emptying or deleting a table
- Renaming moving and copying tables
- Performing other table operations
- Multi-table operations
- Database operations
- Summary
- Chapter 10. Benefiting from the Relational System
- Relational MySQL
- Defining relations with the relation view
- Defining relations with the Designer
- Benefiting from the defined relations
- Column commenting
- Summary
- Chapter 11. Entering SQL Statements
- The SQL query box
- The Query window
- Multi-statement queries
- Pretty printing (syntax highlighting)
- The SQL Validator
- Summary
- Chapter 12. Generating Multi-table Queries
- Choosing tables
- Exploring column criteria
- Generating automatic joins (internal relations)
- Executing the query
- The visual builder
- Summary
- Chapter 13. Synchronizing Data and Supporting Replication
- Synchronizing data and structure
- Supporting MySQL replication
- Summary
- Chapter 14. Using Query Bookmarks
- Comparing bookmark and query history features
- Creating bookmarks
- Recalling bookmarks from the bookmarks list
- Passing a parameter to a bookmark
- Summary
- Chapter 15. Documenting the System
- Producing structure reports
- Generating relational schemas
- Summary
- Chapter 16. Transforming Data using MIME
- Browsing data without transformations
- Enabling transformations
- Examples of transformations
- Summary
- Chapter 17. Supporting Features Added in MySQL 5
- Supporting views
- Supporting routines—stored procedures and functions
- Executing code with triggers
- Using information_schema
- Partitioning
- Exploring the event scheduler
- Summary
- Chapter 18. Tracking Changes
- Understanding the goals of the tracking system
- Prerequisites
- Principles
- Initiating tracking for one table
- Testing the tracking mechanism
- Determining tracking status
- Structure snapshot
- Exporting a version
- Creating a new version
- Deleting tracking information
- Summary
- Chapter 19. Administrating the MySQL Server
- Managing users and their privileges
- Database information
- Server information
- Summary
- Appendix A. Troubleshooting and Support
- Troubleshooting
- Seeking support
- Contributing to the project
- Index 更新時間：2021-08-20 15:55:47
推薦閱讀
- 架構(gòu)不再難（全5冊）
- 趣學Python算法100例
- Python編程完全入門教程
- MariaDB High Performance
- HTML5 and CSS3 Transition，Transformation，and Animation
- Learning Selenium Testing Tools（Third Edition）
- Linux Device Drivers Development
- 基于ARM Cortex-M4F內(nèi)核的MSP432 MCU開發(fā)實踐
- PHP+Ajax+jQuery網(wǎng)站開發(fā)項目式教程
- Spring Boot實戰(zhàn)
- Hands-On Neural Network Programming with C#
- Mastering Gephi Network Visualization
- Java多線程并發(fā)體系實戰(zhàn)（微課視頻版）
- Building Microservices with Go
- 計算機輔助設計與繪圖技術(shù)（AutoCAD 2014教程）（第三版）
- Visual C++ 開發(fā)從入門到精通
- 前端Serverless：面向全棧的無服務器架構(gòu)實戰(zhàn)
- Learning Node.js for Mobile Application Development
- Neo4j權(quán)威指南 （圖數(shù)據(jù)庫技術(shù)叢書）
- ASP.NET 3.5系統(tǒng)開發(fā)精髓
- Python程序設計教程
- Responsive Media in HTML5
- Oracle程序員面試筆試寶典
- 高效C/C++調(diào)試
- 機器學習數(shù)學基礎一本通（Python版）
- Python Django開發(fā)實戰(zhàn)（視頻講解版）
- 基于Kotlin的Spring Boot微服務實戰(zhàn)
- Force.com Enterprise Architecture
- Scratch項目式編程實戰(zhàn)：打造超酷大型游戲
- 從零構(gòu)建Unity 3D游戲：開發(fā)與設計實戰(zhàn)
