JIYIK CN >

Loops are the most fundamental part of full stack development. Loops are very useful when we need to perform similar tasks again and again under certain conditions. In this article, we will see how to use while loop in MySQL, and we will al...

This article describes how to simulate a foreach loop in MySQL using INSERT, SELECT, WHERE, and JOIN in one statement. MySQL foreach loop To understand foreach loop simulation, let us create three tables with the following names and attribu...

In this article, we will learn how to sum multiple columns in MySQL. Sum multiple columns in MySQL You can use aggregate functions SUM() to calculate the total value in a collection. SUM() The function calculation does not consider NULL val...

In this article, we will introduce many ways to check if a database exists in MySQL. Check if the database exists in MySQL The system schema is the schema that MySQL uses. It includes tables that contain data needed by a running MySQL serve...

This article focuses on the various queries that can be used to display the current database in MySQL. We will learn by using the Windows command line and MySQL Workbench. Display the current database in MySQL We can use the following query...

In this article, we will learn about various ways to sort data alphabetically in MySQL. Sort MySQL data alphabetically When you use the SELECT command to query data from a table, the rows in the result set are in arbitrary order. To order t...

In this article, we will learn how to find the difference between two tables in MySQL. The difference between two tables in MySQL We often need to compare two tables to find records in one table that have no matching records in the other ta...

Today, we will learn how to TIMESTAMP insert date and time into a type column of a MySQL table according to the table definition. Create a MySQL table First, we will create the tables that we will use in this tutorial. Sample code: CREATE T...

Today, we will explore three scenarios and their solutions where we want to select the first row from a MySQL table. In the first scenario, we will learn to get the first row from a MySQL table where there are multiple instances of a partic...

Today, we will learn about queries in MySQL that can display the table and database structure. We will use the mysqldump utility, DESCRIBE the , SHOW TABLES and SHOW CREATE TABLE the statements. We are using MySQL version 8.0.28 while writi...

MySQL is an abbreviation for Structured Query Language which is a relational database management system. It is an open source database which is freely available and used for both large and small applications. The use cases are in school app...

In this article we will learn how to connect to a remote MySQL server using Ubuntu to manipulate data and start and stop the MySQL server. Different ways to connect to a remote MySQL server using Ubuntu Data operations from Ubuntu 20.04 cli...

This article presents three alternative implementations that we can use as the equivalent of Oracle's decode() function in MySQL. To do this, we will use IF(), CASE, and a combination of FIELD() and ELT(). MySQL equivalent of Oracle's decod...

This article explains how to update the primary key in a MySQL table. We will use the ALTER command to make any changes to the primary key. Update the primary key in a MySQL table We can update the primary key in a MySQL table in multiple s...

This article will explain how to use mysqldump to back up only the data. Here we will explore the --no-create-info , --compact , , --skip-triggers and --no-create-db options. If you are planning to back up single or multiple databases and t...