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 »
In this tutorial, we will study the execution of the WHILE loop in MySQL. While loop is used to execute one or more than one statement till the condition holds true. The condition is evaluated before evaluating the while loop, so if there is a possibility that it may or may not execute. Basically, we …
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 …
Copying data from one MySQL table to another seems easy but it’s a little tricky. In this tutorial, we’ll learn how to easily copy one table’s data to a new table, how to copy particular columns to another table, how to store a table of one database in another database, and so on. Why do …
How To Copy Table Data in MySQL? [Full Reference] Read More »
In this tutorial, we will study how to change user passwords in MySQL using different statements. In MySQL, a user can change the password of the account using the following statements – UPDATE, SET PASSWORD, and ALTER USER. But first of all, we need to check for which user account the password needs to be …
In this tutorial we’ll be learning how to convert a MySQL table to a CSV file, using the MySQL command line and MySQL Workbench. CSV files or comma-separated value files are simple text files, which store data and separate data from each other using commas and newlines. CSV files are widely used because of their …
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 »
There are several ways to start, stop and restart the MySQL server depending upon the operating system you are using. In this tutorial, we’ll learn how to start-stop and restart MySQL servers in windows, mac, and Linux operating systems. Start, Stop and Restart MySQL Server on Windows There are 3 ways by which you can …