目錄(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
推薦閱讀
- C# 7 and .NET Core Cookbook
- FreeSWITCH 1.8
- Offer來了：Java面試核心知識點精講（原理篇）
- Rake Task Management Essentials
- Learning Python Design Patterns（Second Edition）
- STM32F0實戰：基于HAL庫開發
- TypeScript實戰指南
- JAVA程序設計實驗教程
- Visual Basic程序設計實踐教程
- 硅谷Python工程師面試指南：數據結構、算法與系統設計
- Cybersecurity Attacks：Red Team Strategies
- Odoo 10 Implementation Cookbook
- C語言程序設計與應用（第2版）
- Maker基地嘉年華：玩轉樂動魔盒學Scratch
- Python Programming for Arduino
- Mastering Concurrency in Python
- 現代CPU性能分析與優化
- Vue.js項目開發實戰
- Prezi Cookbook
- Spark Cookbook
- Python商業數據分析：零售和電子商務案例詳解（雙色）
- Node Cookbook
- 寫給UI設計師看的數據可視化設計
- JavaScript核心概念及實踐
- INSTANT Meteor JavaScript Framework Starter
- Blender Cycles：Materials and Textures Cookbook（Third Edition）
- Scratch 3.0少兒編程從入門到精通（全彩版）
- Java Web動態網站開發（微課版）
- iOS開發標準教程
- Intel Galileo Networking Cookbook
