舉報 
會員
Mastering phpMyAdmin 3.4 for Effective MySQL Management
最新章節：
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
推薦閱讀
- Mastering JavaScript Object-Oriented Programming
- Microsoft Dynamics 365 Extensions Cookbook
- C++面向對象程序設計（微課版）
- GeoServer Beginner's Guide（Second Edition）
- HTML5+CSS3網站設計基礎教程
- Scala程序員面試算法寶典
- C++新經典
- Java EE 8 Application Development
- Visual Foxpro 9.0數據庫程序設計教程
- 微信小程序開發與實戰（微課版）
- Mastering C++ Multithreading
- Laravel Application Development Blueprints
- 超簡單：Photoshop+JavaScript+Python智能修圖與圖像自動化處理
- IBM RUP參考與認證指南
- C Primer Plus（第6版）中文版【最新修訂版】
- PHP 7 Programming Blueprints
- JavaScript編程精解（原書第3版）
- Python網絡運維自動化
- Instant Highcharts
- HTML 5+CSS 3+jQuery Mobile移動網站與APP開發實戰
- Python接口自動化測試
- Python實現Web UI自動化測試實戰：Selenium 3/4+unittest/Pytest+GitLab+Jenkins
- Perl語言IC設計實踐
- Java Web程序設計任務教程（第2版）
- Test-Driven Java Development
- Apache Kafka
- Oracle數據庫管理與開發（慕課版）
- Learning PostgreSQL 11
- Java 9 Regular Expressions
- ASP.NET Core 2 and Angular 5
