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 pure SQL statements.
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 how 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 tables within the same database or from one database to another using CREATE TABLE LIKE and SELECT statements in MySQL.
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 results 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 a table is using and how to change the storage engine of the table to a different one.
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.
