Skip to content
Limited-Time Offer: Get lifetime access to 8 eBooks, 3 certification courses, and 5 premium Linux courses with the ROOT Lifetime Plan ($99)
Tecmint: Linux Howtos, Tutorials & Guides
  • Learn Linux
  • Linux Distros
    • Linux Distros for Beginners
    • Linux Distros for Experts
    • New Linux Distros
    • Linux Server Distros
    • Secure Linux Distros
    • CentOS Alternatives
    • RedHat Distributions
    • Debian Distributions
    • Ubuntu Distributions
    • Arch Linux Distros
    • Rolling Linux Distros
    • KDE Linux Distros
    • Linux Distros for Old PC
    • Linux Distros for Kids
    • Linux Distributions for Students
    • Linux Distros for Windows
  • Commands
    • A – Z Linux Commands
    • 100+ Linux Commands
  • Tools
  • Pro Courses
    • Bash Scripting
    • Learn Linux
    • AI for Linux
    • RHCSA Certification
    • RHCE Certification
    • LFCS Certification
  • eBooks
    • RHCSA Exam
    • RHCE Exam
    • LFCS Exam
    • LFCE Exam
    • LFCA Exam
    • Ansible Exam
  • About
    • Contact
    • Hiring
    • Newsletter
    • Testimonials
    • Donate
    • Advertise
    • Submit Article Request
    • Suggest an Update
Tecmint: Linux Howtos, Tutorials & Guides
  • Learn Linux
  • Linux Distros
    • Linux Distros for Beginners
    • Linux Distros for Experts
    • New Linux Distros
    • Linux Server Distros
    • Secure Linux Distros
    • CentOS Alternatives
    • RedHat Distributions
    • Debian Distributions
    • Ubuntu Distributions
    • Arch Linux Distros
    • Rolling Linux Distros
    • KDE Linux Distros
    • Linux Distros for Old PC
    • Linux Distros for Kids
    • Linux Distributions for Students
    • Linux Distros for Windows
  • Commands
    • A – Z Linux Commands
    • 100+ Linux Commands
  • Tools
  • Pro Courses
    • Bash Scripting
    • Learn Linux
    • AI for Linux
    • RHCSA Certification
    • RHCE Certification
    • LFCS Certification
  • eBooks
    • RHCSA Exam
    • RHCE Exam
    • LFCS Exam
    • LFCE Exam
    • LFCA Exam
    • Ansible Exam
  • About
    • Contact
    • Hiring
    • Newsletter
    • Testimonials
    • Donate
    • Advertise
    • Submit Article Request
    • Suggest an Update

MySQL for Beginners

Learn MySQL and MariaDB Advance Functions – Part 2

Learn How to Use Several Functions of MySQL and MariaDB – Part 2

This is the second part of a 2-article series about the essentials of MariaDB / MySQL commands. Please refer to

Learn MySQL / MariaDB for Beginners – Part 1

Learn MySQL / MariaDB for Beginners – Part 1

In this article we will show how to create a database (also known as a schema), tables (with data types),

Upgrade Your Linux Learning with Pro.Tecmint

If you find TecMint helpful, consider supporting us by subscribing to Pro.Tecmint.com – our premium platform with exclusive guides, ad-free experience, early access to tutorials, and much more.

Your support helps us keep creating quality Linux content for everyone.

Get Lifetime Access

Linux Commands and Tools

How to Compare Local and Remote Files in Linux

4 Ways to Find Out What Ports Are Listening in Linux

Dtrx – An Intelligent Archive Extraction (tar, zip, cpio, rpm, deb, rar) Tool for Linux

How to Find a Process Name Using PID Number in Linux

How to Get Total Inodes of Root Partition

Lolcat – Display Text in Rainbow Colors in Linux Terminal

Linux Server Monitoring Tools

Install Glances, InfluxDB and Grafana to Monitor CentOS 7

How to Install htop on CentOS 8

How to Install Zabbix Monitoring Tool on Debian 11/10

How to Monitor Remote Linux Systems with Glances

How to Install Zabbix on RHEL 8

4 Useful Tools to Monitor CPU and GPU Temperature in Ubuntu

Learn Linux Tricks & Tips

5 Ways to Empty or Delete a Large File Content in Linux

Powerline – Adds Statuslines and Prompts to Vim and Bash Shell

How to Add or Remove Linux User From Group

How to Convert Files to UTF-8 Encoding in Linux

How to Configure Custom SSH Connections to Simplify Remote Access

Progress – Show Percentage of Copied Data for (cp, mv, dd, tar) Commands

Best Linux Tools

11 Best GitHub Alternatives to Host Open Source Projects

Top Cross-Platform Apps for Linux, Windows, and Mac in 2025

8 Best IRC Clients for Linux in 2024

8 Best PowerPoint Alternatives for Linux

10 Best PDF Document Viewers for Linux Systems

8 Useful Linux Security Features and Tools for Beginners

Tecmint: Linux Howtos, Tutorials & Guides © 2025. All Rights Reserved.

The material in this site cannot be republished either online or offline, without our permission.

Hosting Sponsored by : Linode Cloud Hosting