In this section, we provide you with advanced MySQL techniques and tips to help you solve the most difficult challenges in MySQL effectively.

Managing Hierarchical Data in MySQL Using the Adjacency List Model

In this tutorial, you will learn how to use the adjacency list model for managing hierarchical data in MySQL.

MySQL Row Count: How to Get Row Count in MySQL

This tutorial shows you various ways to get MySQL row count in the MySQL database.

MySQL Compare Two Tables

This tutorial shows you how to compare two tables to find the unmatched records in MySQL.

How To Find Duplicate Values in MySQL

This tutorial shows you step by step how to find duplicate values in one or more columns in MySQL by using a pure SQL statement.

How To Delete Duplicate Rows in MySQL

In this tutorial, you will learn how to delete duplicate rows in MySQL by using the DELETE JOIN statement or an immediate table.

MySQL UUID Smackdown: UUID vs. INT for Primary Key

This tutorial introduces you to MySQL UUID , shows you to use it as the primary key (PK) for a table, and discusses the pros and cons of using it as the PK.

MySQL Copy Table With Examples

This tutorial shows you how to copy table within the same database or from one database to another using CREATE TABLE LIKE and SELECT statements in MySQL.

How To Copy a MySQL Database

This tutorial shows you how to copy a MySQL database on the same server and from a server to another.

MySQL Variables

In this tutorial, you will learn how to use MySQL user-defined variables in SQL statements.

MySQL SELECT INTO Variable

This tutorial shows you how to use the MySQL SELECT INTO variable to store query result in one or more variables.

How To Compare Successive Rows Within The Same Table in MySQL

In this tip, we will show you how to compare or to calculate the difference between successive rows by using INNER JOIN in MySQL

How To Change MySQL Storage Engine

In this tutorial, you will learn how to which storage engine that a table is using and how to change the storage engine of the table to a different one.

MySQL REGEXP: Search Based On Regular Expressions

In this tutorial, you will learn about regular expression and how to use the MySQL REGEXP operator to query data using many regular expression examples.

MySQL ROW_NUMBER, This is How You Emulate It

In this tutorial, we will show you a useful tip that emulates the row_number function in MySQL.

MySQL Select Random Records

Shows you various techniques to select random records from a database table.

How To Select The nth Highest Record In MySQL

In this tutorial, you will learn how to the nth highest record in a database table using various techniques.

MySQL Reset Auto Increment Values

This tutorial shows you various ways to reset auto increment values of AUTO_INCREMENT columns in MySQL.

MariaDB vs. MySQL

The following table illustrates the main differences between MariaDB and MySQL: MySQL MariaDB Developer Oracle Corporation MariaDB Corporation AB (MariaDB Enterprise), MariaDB Foundation (community MariaDB Server) Protocols MySQL MySQL +…

MySQL Interval

This tutorial shows you step by step how to use the MySQL interval for date and time arithmetic with many practical examples.

MySQL NULL: The Beginner’s Guide

In this tutorial, you will learn how to work with MySQL NULL values. In addition, you’ll learn some useful functions to deal with the NULL values effectively.

How to Get MySQL Today’s Date

This tutorial shows you how to get MySQL today’s date by using the CURDATE() or NOW() functions. Also, you learn how to create the today() stored function.

How To Map NULL Values To Other Meaningful Values

You will learn how to map NULL values onto other values for a better data representation.

MySQL Comment In Depth

This tutorial shows you how to use MySQL comment to document an SQL statement or a block of code.