JIYIK CN >

This quick tutorial will discuss backing up a MySQL database and saving it in a file as a script. When working with a database, it is recommended to back up the database regularly. This is because some problematic situations may arise durin...

This tutorial explains three methods named LAST_INSERT_ID() , , MAX() and through code examples ORDER BY DESC and demonstrates how to get the ID of the most recently inserted record in MySQL. Get the ID of the most recently inserted record...

In this article, we aim to explore how to sort data alphabetically in MySQL database. Sorting is the ordering of elements or values ​​in an array or column based on a particular criteria. In this tutorial, we will set the criteria as al...

MySQL has various operations that facilitate the use and maintenance of relational databases. It has various built-in functions that help in the use of this tool. These functions simplify manual work by taking parameters and providing resul...

This article shows you how to add dates and times in MySQL using DATE_ADD() the _date_time_s() function. We will learn how to add or subtract days, years, months, and times individually, as well as how to combine the two (for example, days...

In this article, we will learn to use CONCAT() the and CONCAT_WS() functions to concatenate or append string values ​​in MySQL fields. Use CONCAT() and CONCAT_WS() to append a string to an existing field in MySQL To understand CONCAT()...

In this article, we will learn how to revoke MySQL privileges. Revoking Privileges in MySQL The actions that a MySQL account is allowed to perform depend on the privileges assigned to it. The context in which each type of MySQL privilege is...

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...