Book Image

MariaDb Essentials

By : Kenler
Book Image

MariaDb Essentials

By: Kenler

Overview of this book

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.
Table of Contents (10 chapters)
9
Index

Working with databases


An RDBMS allows you to store data in a structured way, with relations between the different data collections. These collections of data are stored in tables. However, each table is located in a database. We can see this structure as a container for tables and other objects. In MariaDB, schema is a synonym for database and is used in the documentation as well as in the statement syntax.

To list the existing databases, we can use the SHOW DATABASES statement. Let's try it on our newly installed MariaDB:

MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.09 sec)

As we can see in this code snippet, there are several built-in databases. They are as follows:

  • information_schema: A virtual database containing various meta-information about our data structures and server usage. It can be read, but not directly modified...