In this section, we provide you with advanced MySQL techniques and tips to help you solve the most difficult challenges in MySQL effectively.
In this tutorial, you will learn how to use the adjacency list model for managing hierarchical data in MySQL.
This tutorial shows you various ways to get MySQL row count in the MySQL database.
This tutorial shows you how to compare two tables to find the unmatched records 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.
In this tutorial, you will learn how to delete duplicate rows in MySQL by using the DELETE JOIN statement or an immediate table.
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.
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.
This tutorial shows you how to copy a MySQL database on the same server and from a server to another.
In this tutorial, you will learn how to use MySQL user-defined variables in SQL statements.
This tutorial shows you how to use the MySQL SELECT INTO variable to store query result in one or more variables.
In this tip, we will show you how to compare or to calculate the difference between successive rows by using INNER JOIN in MySQL
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.
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.
In this tutorial, we will show you a useful tip that emulates the row_number function in MySQL.
Shows you various techniques to select random records from a database table.
In this tutorial, you will learn how to the nth highest record in a database table using various techniques.
This tutorial shows you various ways to reset auto increment values of AUTO_INCREMENT columns in 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 +…
This tutorial shows you step by step how to use the MySQL interval for date and time arithmetic with many practical examples.
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.
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.
You will learn how to map NULL values onto other values for a better data representation.
This tutorial shows you how to use MySQL comment to document an SQL statement or a block of code.