MariaDB – Installation
All downloads for MariaDB are located in the Download section of the official MariaDB foundation website. Click the link to the version you would like, and a list of downloads for multiple…
Linux Admin – System Updates
In this section, we will learn how to take Linux system updates. The CentOS 7 system can be updated in three ways − ManuallyAutomaticallyUpdate manually for major security issues and…
MariaDB – Introduction
A database application exists separate from the main application and stores data collections. Every database employs one or multiple APIs to create, access, manage, search, and replicate the data it…
MariaDB
MariaDB is a fork of the MySQL relational database management system. The original developers of MySQL created MariaDB after concerns raised by Oracle's acquisition of MySQL. This tutorial will provide…
Linux Admin – Backup and Recovery
In this section, we will know about the linuxs backup and recovery. Backup Strategy Throughout the industry, you'll often hear the term 3-2-1 backup model.3-2-1 is defined as follows: 3 copies of…
MariaDB – Indexes & Statistics Tables
Indexes & Statistics Tables are tools for accelerating record retrieval. An index spawns an entry for each value within an indexed column. There are four types of indexes − Primary (one…
MariaDB – Alter Command
The Alter command provides a way to change an existing table's structure, meaning modifications like removing or adding columns, modifying indices, changing data types, or changing names. ALTER also waits…
MariaDB – Transactions
Transactions are sequential group operations. They function as a single unit, and do not terminate until all operations within the group execute successfully. A single failure in the group causes…
MariaDB – Regular Expression
Beyond the pattern matching available from LIKE clauses, MariaDB offers regular expression-based matching through the REGEXP operator. The operator performs pattern matching for a string expression based on a given…
MariaDB – Null Values
When working with NULL values, remember they are unknown values. They are not empty strings or zero, which are valid values. In table creation, column specifications allow for setting them…
- Go to the previous page
- 1
- …
- 725
- 726
- 727
- 728
- 729
- 730
- 731
- …
- 739
- Go to the next page