MySQL/MariaDB: Tutorials

Prerequisites

The following tutorials take into consideration that you already have a basic installation of MySQL/MariaDB. If not, there are many great documentations around to get you started.

• Arch Linux
• RHEL / CentOS
• Fedora
• Ubuntu
• Windows
• MacOS

Getting Started

Create a user

Grant User Permissions

The Basics

List the Databases

List the Tables

Describe the Table's Columns

Add a new Column in a Table

Remove a Column in a Table

Manipulating the Data

Insert data in Table

Select data from Table

Sort data Ascending/Descending

Update data in Table

Advance Topics