MariaDB Essentials

Quickly get up to speed with MariaDB―the leading, drop-in replacement for MySQL, through this practical tutorial

About This Book

• Get to know the basic SQL queries so you can quickly start using MariaDB
• Take control of your data through the advanced features of MariaDB
• Exploit the full potential of MariaDB's exclusive features through quick, practical examples

Who This Book Is For

If you don't know the SQL language, but you want to quickly jump into the SQL world and learn how to use MariaDB, or if you already know how to use MySQL but you want to go further, then this book is ideal for you.

What You Will Learn

• Install and configure MariaDB
• Create databases, tables, and indexes
• Import and export data from and to external files
• Work with views and virtual columns
• Create, read, update, and delete records in your database
• Use dynamic columns
• Set up a powerful full-text search system
• Access your external data from MariaDB through the CONNECT engine

In Detail

This book will take you through all the nitty-gritty parts of MariaDB, right from the creation of your database all the way to using MariaDB's advanced features.

At the very beginning, we show you the basics, that is, how to install MariaDB. Then, we walk you through the databases and tables of MariaDB, and introduce SQL in MariaDB. You will learn about all the features that have been added in MariaDB but are absent in MySQL.

Moving on, you'll learn to import and export data, views, virtual columns, and dynamic columns in MariaDB. Then, you'll get to grips with full-text searches and queries in MariaDb. You'll also be familiarized with the CONNECT storage engine. At the end of the book, you'll be introduced to the community of MariaDB.

Style and approach

This is a complete guide that uses concrete examples to help you understand and exploit the full potential of MariaDB.

快速掌握MariaDB - MySQL的領先替代品，通過這本實用教程。

關於本書：
- 了解基本的SQL查詢，以便快速開始使用MariaDB。
- 通過實際示例，掌握MariaDB獨有功能的全部潛力。

適合閱讀對象：
- 如果您不熟悉SQL語言，但想快速進入SQL世界並學習如何使用MariaDB，或者您已經知道如何使用MySQL但想更進一步，那麼這本書非常適合您。

您將學到的內容：
- 安裝和配置MariaDB。
- 創建數據庫、表和索引。
- 導入和導出數據到外部文件。
- 使用視圖和虛擬列。
- 在數據庫中創建、讀取、更新和刪除記錄。
- 使用動態列。
- 建立強大的全文搜索系統。
- 通過CONNECT引擎從MariaDB訪問外部數據。

詳細內容：
本書將帶您深入了解MariaDB的方方面面，從創建數據庫到使用MariaDB的高級功能。

一開始，我們會向您展示基本知識，即如何安裝MariaDB。然後，我們將引導您了解MariaDB的數據庫和表，並介紹MariaDB中的SQL。您將了解到在MariaDB中新增的所有功能，而這些功能在MySQL中是缺失的。

接下來，您將學習在MariaDB中導入和導出數據、使用視圖、虛擬列和動態列。然後，您將熟悉MariaDB中的全文搜索和查詢。您還將瞭解CONNECT存儲引擎。在本書的最後，您將認識到MariaDB社區。

風格和方法：
這是一本完整的指南，使用具體的示例幫助您理解和充分利用MariaDB的潛力。