目錄(78章)
倒序
- coverpage
- MariaDB Essentials
- Credits
- About the Authors
- 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. Installing MariaDB
- Choosing a MariaDB version
- Installing MariaDB
- Starting and stopping MariaDB
- Getting started with the mysql client
- Configuring MariaDB
- Upgrading MariaDB
- Managing plugins
- Summary
- Chapter 2. Databases and Tables
- Working with databases
- Working with tables
- Working with columns
- Storage engines
- Indexing
- Using comments
- Working with metadata
- Creating an installation script
- Summary
- Chapter 3. Getting Started with SQL
- Working with rows
- Understanding transactions
- Foreign keys
- Dealing with duplicates and consistency errors
- Reading rows
- Joining tables
- Working with operators
- Working with times and dates
- Using comments to annotate your database schema
- Summary
- Chapter 4. Importing and Exporting Data
- The basics of importing and exporting data
- Creating and importing CSV files
- Creating and importing a dump file
- Speeding up data import
- Summary
- Chapter 5. Views and Virtual Columns
- Views
- Virtual and persistent columns
- Summary
- Chapter 6. Dynamic Columns
- The problem: storing non-homogeneous data
- Dynamic columns
- Summary
- Chapter 7. Full-Text Searches
- Defining a full-text search
- Full-text searches in MySQL and MariaDB
- Working with full-text indexes
- Full-text queries
- Mroonga
- Connecting MariaDB to Sphinx
- Summary
- Chapter 8. Using the CONNECT Storage Engine
- Understanding the CONNECT storage engine
- Accessing CSV files
- Accessing XML and HTML files
- Using the XCOL table type
- Using the OCCUR table type
- Using the PIVOT table type
- The MariaDB community
- MariaDB resources
- Included storage engines
- Summary
- Index 更新時間：2021-07-09 21:39:27
推薦閱讀
- Unity 2020 By Example
- 深入核心的敏捷開發：ThoughtWorks五大關鍵實踐
- 數據庫程序員面試筆試真題與解析
- Docker進階與實戰
- TypeScript圖形渲染實戰：基于WebGL的3D架構與實現
- Silverlight魔幻銀燈
- Python高效開發實戰：Django、Tornado、Flask、Twisted（第3版）
- 劍指MySQL：架構、調優與運維
- Angular開發入門與實戰
- Oracle GoldenGate 12c Implementer's Guide
- QGIS Python Programming Cookbook（Second Edition）
- Flowable流程引擎實戰
- C++程序設計教程（第2版）
- Python Digital Forensics Cookbook
- 自己動手構建編程語言：如何設計編譯器、解釋器和DSL
- JavaScript Unit Testing
- 計算機軟件項目實訓指導
- 算法（第4版）
- Learning Java by Building Android Games
- Web應用程序設計：ASP
- 新手學Visual C
- Java核心技術卷I基礎知識（原書第9版）
- Python深度學習實戰：基于TensorFlow和Keras的聊天機器人以及人臉、物體和語音識別
- HTML5+CSS3開發實戰
- 面向對象的思考過程（原書第5版）
- Docker與Kubernetes容器虛擬化技術與應用
- Java修煉指南：核心框架精講
- 40 Algorithms Every Programmer Should Know
- JSP網絡程序設計與案例開發教程
- Java多線程編程核心技術（第3版）
