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

Understand Linux Shell and Basic Shell Scripting Tips – Part I

How to Add, Delete and Update Files in Tar Archive in Linux

18 Tar Command Examples in Linux

How to Clone a Partition or Hard drive in Linux

How to Restrict SFTP Users to Home Directories Using chroot Jail

How to Find Out List of All Open Ports in Linux

Linux Server Monitoring Tools

20 Netstat Commands for Linux Network Management

Sysdig – A Powerful System Monitoring and Troubleshooting Tool for Linux

Install OpenNMS Network Monitoring Tool in CentOS/RHEL 7

24 Best Command Line Tools to Monitor Linux Performance

ngxtop – Monitor Nginx Log Files in Real Time in Linux

Psensor – Monitor Linux Hardware Temperature [Motherboard and CPU]

Learn Linux Tricks & Tips

How to Transfer Files Between Two Computers using nc and pv Commands

How to Optimize and Compress JPEG or PNG Images in Linux Commandline

How to Clear BASH Command Line History in Linux

3 Ways to List All Installed Packages in RHEL, CentOS and Fedora

How to Count Word Occurrences in a Text File

Powerline – Adds Statuslines and Prompts to Vim and Bash Shell

Best Linux Tools

15 Best Open Source Music Making Software for Linux in 2024

8 Best PowerPoint Alternatives for Linux

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

11 Best PDF Editors to Edit PDF Documents in Linux

7 Best CCleaner Alternatives for Ubuntu

16 Best Microsoft Teams Alternatives For Linux in 2024

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