Ritika

This article will discuss how to insert rows in a MySQL table using a loop. Apart from integer and string data types, we will also cover how to insert dates in a loop and control loops with date-specific conditions. Table of Contents MySQL Insert Rows in a Loop MySQL Insert Date Loop MySQL Insert Rows […]

In this article, we will go through a few examples of For Loop in MySQL. Like other languages, MySQL also provides LOOP functionality to execute one or more statements multiple times. The statements within the loop repeat until the LOOP gets terminated. Table of Contents MySQL For Loop Syntax MySQL For Loop Examples MySQL For

In this article, we will be looking into how to convert columns to rows. There is often a requirement to get the column-specific data represented as rows and get the necessary information associated with them. Let us get started by looking into the sample data we will be using in our examples. Assume that we

In this article, we will be looking into how to convert rows to columns. There is often a requirement where we want to get the row data represented as columns and get the necessary information associated with them. Table of Contents Introduction MySQL: convert rows to columns – using CASE MySQL: convert rows to columns

This article will be looking into how to get the column names and their corresponding data types in a MySQL table. Table of Contents Get column names and datatypes – using information schema Get column names and datatypes – using SHOW COLUMNS Let us get started by making the data to be used across the

This article will be looking into how to add multiple columns after the last or a specific column in MySQL. Table of Contents MySQL- how to add multiple columns after the last column MySQL -how to add multiple columns after a specific column MySQL -how to add multiple columns after different specific columns MySQL -how

In this article, we will see how to delete a column from a table in MYSQL. Table of Contents MySQL delete column from a table – syntax MySQL delete column from a table – example MySQL drop a column with foreign key Before moving ahead into the tutorial, let us look at the data we

In this article, we will be discussing the differences between JOIN and UNION including examples of how to use them. Table of Contents Introduction Basic differences between JOIN and UNION Examples of JOIN and UNION Introduction JOIN is used to retrieve data from multiple tables. Data retrieved from JOINs are horizontally aligned. A JOIN is

‘IF’ in ‘SELECT’ statements is used to get the output based on a column value. This article will see how to get output in ‘SELECT’ statements based on ‘IF’ in a MySQL query. Table of Contents ‘IF’ with ‘SELECT’ using – IF() function ‘IF’ with ‘SELECT’ using – case SELECT with UNION Before moving into

This article will be looking into queries to select from multiple tables through different ways for different requirements. Table of Contents Select from multiple tables MySQL using JOINS Select from multiple tables MySQL using UNIONS Select from multiple tables MySQL using Subqueries Select from multiple tables MySQL with IN() Before moving into each section, let