Comments are a very important part of any programming language. MySQL also provides us with the feature of comments. Like any other programming language, there are multiple types of comments available in MySQL. In this tutorial, we will learn what are the different types of comments in MySQL and how to use them with practical …
MySQL Comments – How To Add Comments To Your Queries Read More »
In this tutorial, we will learn how to add a new column to the table in an easy way. Along with it, we will see how we can add more than one column to the table and how to add a new column before or after a particular existing column. This is going to be …
Many times you may have faced the situation where you wanted to compare two tables and get unmatched records out of them. This is a common practice when database migration is done. So in this tutorial, we will learn how to compare two tables to find unmatched records. So, let’s get started! Prerequisites In MySQL, …
Compare Two Tables in MySQL – Find Records Without Matches Read More »
In this tutorial, we will learn what is a stored function, its syntax, how it works, why do we need it and at the last, we will see a practical example to understand it better. If you know about MySQL stored procedures, then it is easier to understand the stored function. However, it is not …
MySQL Stored Function with Example – A Complete Reference Read More »
We can easily call the stored procedure from the MySQL workbench or MySQL CLI. But have you ever tried to call it from PHP and failed? Don’t worry now because, in this tutorial, we will learn to call a stored procedure from a PHP program. We will see two examples of different types so that …
Calling MySQL Stored Procedure In PHP [Easy Reference] Read More »
In this tutorial, we will learn about the LOOP statement in MySQL. It is very similar to the other loops in MySQL such as REPEAT and WHILE but has a different syntax. This is going to be an interesting tutorial because we will see two examples of the LOOP statement to understand it in a …
Today we will learn how can we use loops in a MySQL stored procedure. We will see three different examples in which we will use different types of loops in the stored procedure. First, we will see the syntax of loops, and then we will use them inside the stored procedure. We will use only …
In this tutorial, we will be looking at how we can return multiple values from the stored procedure. After one practical example, we will see how can we implement the same example in PHP. Let’s dive into it. Also read: Create MySQL Stored Procedure [With Examples] Before We Start MySQL stored function can return only …
Return Multiple Values in MySQL Stored Procedure Read More »
In this tutorial, we will be seeing parameters in MySQL stored procedure. We will learn what are the different types of parameters the stored procedure supports, their syntax, and examples to understand the topic more effectively. Introduction to Stored Procedure Parameters In MySQL, stored procedures are supposed to be one of the most important parts …
MySQL Stored Procedure Parameter Types and Examples Read More »
Variables are a very important part of any programming language. Although MySQL is not a programming language, variables are still its vital domain. In this tutorial, we will learn about user-defined variables which are also known as session variables in MySQL. This is going to be a detailed guide on MySQL user-defined variables where we …