Concatenation of two rows

Passing An Array To A Query Using A WHERE Clause

by

In this post, we will discuss How to Passing An Array To A Query Using A WHERE Clause using a ‘where’ clause along with the ‘in’ operator for the same we have given an example here. Passing An Array The Syntax for the same is given below here. SELECT * FROM table _name WHERE column_ … Read more

Relationships | Give Many-To-Many And One To One Relationships Examples

by

In this post, we will discuss the different types of Relationships of databases that have different types of relations like many to many, One to one, and too many relationships, and here we will explain along with certain examples of each to understand it better. Different Relationships of Databases There are three types of relationship … Read more

What Is The Difference MySQLi vs MySQL when using PHP

by

In this post, we will get to know the difference between MySQL vs MySQLi when using PHP where these are two different extensions in PHP used for connection to the working with MySQL database there are a number of differences in between them that we will discuss here one by one. MySQLi Vs MySQL There … Read more

MySQL: @variable vs. Variable. What’s the difference?

by

In this post, we will get to know the difference between @variable and Variable. where we use the ‘@ ‘ sign only for showing that that particular variable is available only for that particular session only.  Something same to local and global variables. On the other hand, variables defined without ‘@’ are user-defined variables, which … Read more

How to Calculate a running total in MySQL?

by

In this post, we will discuss how to Calculate a running total in MySQL where we can create a user-defined variable that will be used for keeping track or record of the sum at every level and continue to add. And even we can use a subquery and a join also for the same. And … Read more

How Do I Query Between Two Dates Using MySQL?

by

In this post, we will discuss How to query between two dates using MySQL which we can perform using between the operator along with the date function, However, we need to keep the date format as standard. It is nothing but just a way to get the data of all the records where in the … Read more

UTF-8 | How To Convert An Entire MySQL Database Character Set and Collation to UTF-8?

by

In this Tutorial, we will learn more about How to convert an entire MySQL database character set and collation to UTF-8 for doing the same we need to follow certain steps which we had listed here along with the required code that we need to execute during this conversion. Conversion Into UTF-8 Follow the steps … Read more

How to Create a Cumulative Sum Column in MySQL?

by

In this post, we will discuss how to create a Cumulative Sum Column in MySQL where we can use any user-defined variable for keeping the track of the sum and continue to add on. And even we can use subquery and a join. And here we will discuss both ways to achieve our desired output … Read more

Files | How Can I Output MySQL Query Results In CSV Format?

by

In this post, we will discuss How can I output MySQL query results in CSV files format which we can do using select into outfile statement before giving the name of the file along with the extension. Files Extraction in CSV Format We can get a csv format of the data stored in a database … Read more

Laravel | How to use multiple databases in Laravel?

by

In this post, we will discuss How to use multiple databases in Laravel which we can perform using separate database connections for each database in the config/ database.php file for the same we have given an example of code to understand it better. Laravel We have given an example here to understand it in better … Read more

%d bloggers like this: