MySQL Examples and Tutorials
In this tutorial, we will learn how we can handle the duplicate insertion of the record in a MySQL table. It is a very easy process and needs a single statement which is the “INSERT ON DUPLICATE KEY UPDATE”. Make sure you read the tutorial carefully and try it to understand it properly. So, let’s …
In this tutorial, we will learn how we can return specific values or data from the JSON document using the MySQL function JSON_EXTRACT(). It is super simple to understand and implement. We will see multiple examples and ways to extract the values from the JSON data in this tutorial. So without further ado, let’s get …
MySQL JSON_EXTRACT – How to Extract Data From JSON Document? Read More »
In this tutorial, we will learn everything about the SMALLINT datatype in MySQL. It is similar to the integer datatype but has a smaller range. So, let’s get started! Also read: MySQL INT Datatype Brushing Up the Basics MySQL provides us with multiple versions of integer datatype such as TINYINT, SMALLINT, MEDIUMINT, INT, and BIGINT. …
Everything You Need to Know About MySQL SMALLINT Read More »
In this tutorial, we will learn about the UPDATE JOIN statement. The UPDATE JOIN statement is basically used to update the table data based on the joins. We will see how to perform the update join operation using the left join as well as the inner join. So, let’s get started! Also read: MySQL FULL …
In this tutorial, we will learn about the “not equal” operator in MySQL which is used to find the records which are not equal to a given expression. So, let’s get started! Introduction to MySQL Not Equal To Operator The “Not equal to” operator is exactly opposite to the equal to operator. When you want …
In this tutorial, we will learn about the REGEXP_LIKE() function which is used to match the given value with the specified regular expression. So, let’s get started! What is a Regular Expression? In your application, you will often need to find the result that matches a specific pattern. The LIKE operator is a good option …
In this tutorial, we will learn about the VARCHAR datatype in MySQL. We will see what is a VARCHAR datatype, its minimum and maximum limit and what characters are valid as a VARCHAR datatype. So, let’s get started! Also read: MySQL INT Datatype Introduction to MySQL VARCHAR The first and most important point before getting …
In this tutorial, we will see how can we list all the databases in MySQL using CLI as well as the MySQL workbench. There are multiple ways you can list all the databases using CLI. We will see all the available methods out there. So, let’s get started! Also read: MySQL Show Users – A …
In this tutorial, we will discuss the difference between the view processing algorithms merge and temptable. This is going to be a comparative guide on how these two view processing algorithms differ from each other by performance and use cases. So, let’s get started! Also read: MySQL ALTER View Introduction to the MERGE Algorithm When …
MySQL TEMPTABLE vs MERGE – View Performance Comparison Read More »
In this tutorial, we will learn how to alter an existing view in MySQL using the ALTER VIEW statement. This is a super simple process, therefore it will take very little time. Also, we will see how can we alter a view using two methods- using a MySQL CLI and using a MySQL workbench. So, …