Skip to content
NEW: Get Lifetime access to 8 courses, 3 certifications, 5 eBooks, and all future courses for just $199 - [Claim Offer]
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 Find and Sort Files Based on Modification Date and Time in Linux

How to Identify Working Directories Using Shell Characters and Variables

Linux zcat Command Examples for Newbies

Mhddfs – Combine Several Smaller Partition into One Large Virtual Storage

15 Must-Know FFmpeg Commands for Video, Audio & Image Conversion

How to Compare Local and Remote Files in Linux

Linux Server Monitoring Tools

Darkstat – A Web Based Linux Network Traffic Analyzer

IPTraf-ng – A Console-Based Network Monitoring Tool

How to Install Icinga2 Monitoring Tool on OpenSUSE

Swatchdog – Simple Log File Watcher in Real-Time in Linux

How to Install Nagios Monitoring Tool on RHEL 8

How to Install Cacti on Rocky Linux and AlmaLinux

Learn Linux Tricks & Tips

How to Auto Execute Commands/Scripts During Reboot or Startup

How to Find a Specific String or Word in Files and Directories

How to Use ‘Yum History’ to Find Out Installed or Removed Packages Info

How to Create a Virtual HardDisk Volume Using a File in Linux

Translate rwx Permissions into Octal Format in Linux

10 Useful Sudoers Configurations for Setting ‘sudo’ in Linux

Best Linux Tools

10 Best API Gateways and Management Tools in 2024

10 Best Tools to Install on Fresh Linux Mint Installation

Top 5 Open-Source Enterprise Software for Linux in 2024

5 Best Open-Source eLearning Platforms for Linux in 2024

Top 5 Open-Source OCR Tools for Linux in 2025

Top 7 Apps to Install for Your Nextcloud Instance

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

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

Hosting Sponsored by : Linode Cloud Hosting