In this tutorial, we will see what is the INSTR function, what are its applications, and how to use it through simple and effective examples. Also read: MySQL Insert Ignore – A Complete Guide Introduction to the INSTR Function The INSTR function accepts two parameters. The first is the main string and the second is …
In this tutorial, we will learn what NULL value is and how to work with NULL values in the MySQL database. We will also see some useful functions that MySQL provides to deal with NULL values. So, let’s get started! Introduction to MySQL NULL There are misconceptions between NULL and 0 in beginners. In MySQL, …
In this tutorial, we will learn about MySQL JSON data type and how to use it inside the SQL queries to perform operations using simple and effective examples. Introduction to MySQL JSON Datatype The JSON datatype was introduced in MySQL version 5.7.8 which allows you to store and access the data in JSON documents. JSON …
In this tutorial, we will see what is the INTERSECT operator and what is its use. It is one of the three set operators in SQL standard- UNION, INTERSECT and MINUS. We will see two examples to emulate the intersect in MySQL. Note that, MySQL does not support the INTERSECT operator. In this tutorial, we …
MySQL INTERSECT – Find Similar Rows in Multiple Tables Read More »
In this tutorial, we will see what is the MINUS operator and how to use it in the query using a simple example. It is one of the three set operators – UNION, INTERSECT and MINUS. MySQL Doesn’t provide the MINUS Operator. We will perform the MINUS operation using MySQL Join clause. Also read: Introduction …
In this tutorial, we will learn what is hierarchical data, what is adjacency list mode and how to manage hierarchical data in MySQL using the adjacency list model. So, let’s get started! Introduction to Adjacency List Model and Hierarchical Data Hierarchical data means the data is organized in a tree fashion, i.e., in a hierarchical …
MySQL Adjacency List Model For Managing Hierarchical Data Read More »
It is very important to know information about compatible as well as up-to-date connectors and APIs before performing database connections and operations. Also read: Introduction To MySQL Full-Text Search What is MySQL a Connector? MySQL Connectors are the piece of software that provides connectivity between a programming language and MySQL server and APIs provide low-level …
In this tutorial, we will learn what is recursive CTE and how to write a recursive CTE query. Recursive CTE is very similar to regular CTE which starts with the WITH clause but, it calls itself for n interactions until the condition becomes false. Let’s see how the characteristic of recursive CTE and how it …
In MySQL, if we want to get the final result from the result of another query, we usually use derived tables to store the result of the previous query. However, MySQL provides us with another way to perform the same operation in a better way. We can use MySQL CTE which stands for common table …
When you insert the data into the table but skip some values for a particular column(S), NULL will get inserted into it. The NULL indicates an unknown value or missing value. On the user side, it is very important to show only meaningful data and not NULL. You can show messages such as N/A, no …