Most Used Categories

Databases , Learn MariaDB

MariaDB – Backup Loading Methods

MariaDB – Backup Loading Methods, In this chapter, we will learn about various backup loading methods. Restoring a database from a backup is a simple and sometimes terribly long process.…Read More

Databases , Learn MariaDB

MariaDB – Managing Duplicates

MariaDB – Managing Duplicates, MariaDB, as discussed in earlier lessons, allows duplicate records and tables in some situations. Some of these duplicates are not in fact duplicates due to dis…Read More

Databases , Learn MariaDB

MariaDB – SQL Injection Protection

MariaDB – SQL Injection Protection, The simple act of accepting user input opens the door to exploits. The problem stems primarily from the logical management of data, but luckily, it is fairly ea…Read More

Databases , Learn MariaDB

MariaDB – Backup Methods

MariaDB – Backup Methods, Data serves as the foundation of business and operations, and with various possible threats (e.g., attackers, system failures, bad upgrades, and maintenance err…Read More

Databases , Learn MariaDB

MariaDB – Temporary Tables

MariaDB – Temporary Tables, Some operations can benefit from temporary tables due to speed or disposable data. The life of a temporary table ends at the termination of a session whether yo…Read More

Databases , Learn MariaDB

MariaDB – Table Cloning

MariaDB – Table Cloning, Some situations require producing an exact copy of an existing table. The CREATE…SELECT statement cannot produce this output because it neglects things like i…Read More

Databases , Learn MariaDB

MariaDB – Sequences

MariaDB – Sequences, In version 10.0.3, MariaDB introduced a storage engine known as sequence. Its ad hoc generates an integer sequence for operations, and then it terminates. The s…Read More