目錄(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 更新時(shí)間:2021-07-09 21:39:27
推薦閱讀
- Getting Started with Gulp(Second Edition)
- SQL Server 2016從入門到精通(視頻教學(xué)超值版)
- Oracle從新手到高手
- C語言程序設(shè)計(jì)立體化案例教程
- Julia Cookbook
- Mastering Ext JS
- Flutter跨平臺(tái)開發(fā)入門與實(shí)戰(zhàn)
- 移動(dòng)界面(Web/App)Photoshop UI設(shè)計(jì)十全大補(bǔ)
- Learning Probabilistic Graphical Models in R
- OpenGL Data Visualization Cookbook
- Learning VMware vSphere
- 寫給大家看的Midjourney設(shè)計(jì)書
- Learning Grunt
- Visual Basic程序設(shè)計(jì)基礎(chǔ)
- Access 2016數(shù)據(jù)庫應(yīng)用與開發(fā):實(shí)戰(zhàn)從入門到精通(視頻教學(xué)版)
- Mastering R for Quantitative Finance
- Azure for Architects
- TensorFlow程序設(shè)計(jì)
- Implementing OpenShift
- The Ruby Workshop
- 高性能Scala
- 性能之道:分布式系統(tǒng)全棧性能優(yōu)化
- Java高級(jí)特性編程及實(shí)戰(zhàn)
- Troubleshooting Ubuntu Server
- RESTful Web Services with Dropwizard
- INSTANT Kendo UI Mobile
- Microsoft Tabular Modeling Cookbook
- 尋聲記:Scratch 3.0趣味編程之旅(全彩)
- 前端開發(fā)必知必會(huì):從工程核心到前沿實(shí)戰(zhàn)
- TypeScript+Vue.js前端開發(fā)從入門到精通