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

In this guide, we will learn about recursive queries in MySQL. How to write recursive queries in SQL and how it works will be explained in this guide for your better understanding. MySQL recursive query A recursive query in SQL is a subquer...

Want to convert your string to lowercase, but don't know how to do it efficiently? We've got you covered. MySQL convert string to lower case The trick is that MySQL provides a function, namely LCASE() , or Lower() . Both of these can be use...

A database administrator may occasionally need to add a record to a MySQL table, or update a frequently occurring record. MySQL will send an alert if a user attempts to insert a record that already exists or has a duplicate PRIMARY KEY valu...

We will learn how to integrate ElasticSearch with MySQL. We will also look at some of the key differences between JSON format databases and relational databases. Integrating ElasticSearch with MySQL As we all know, MySQL is a relational-bas...

The main purpose of this topic is to demonstrate how to clear the MySQL console screen. Clearing the Screen in MySQL When working on the MySQL Console and managing configuration and data, the screen can become overly cluttered with the resu...

In this article, we aim to understand how to use CASE WHEN statement in MySQL database. Businesses and organizations that process large amounts of data need to filter data based on specific conditions. If there are multiple conditions, it i...

This article demonstrates several ways for users to delete all tables in MySQL and lists sample scripts to implement this method. The reason you can't just drop all the tables in one line of code is that in a large and well-designed databas...

Today, we will understand the difference between the WHERE and clauses in MySQL . We will understand these clauses individually with code examples and compare them in a tabular form to highlight the differences. HAVING In WHERE MySQL HAVING...

This article teaches you how to use MySQL VIEW and MERGE create table aliases. In both cases, changes in the original table are reflected in the alias table. Also, SELECT query results on the alias table and the original table will be the s...

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

This article aims to understand how to sort values ​​by date in MySQL. Most of the businesses and organizations that use MySQL for data analysis or data visualization need to sort different table values ​​of their users based on dat...

Today, we will enable MySQL in MySQL using MySQL shell on Windows and Ubuntu 20.04 slow_query_log . For this tutorial, we are using MySQL version 8.0 and Ubuntu 20.04. MySQL slow_query_log MySQL slow_query_log contains SQL statements that t...

In this article, we will learn how to add an auto-increment column in MySQL. Adding an auto-increment column in MySQL When creating a table, we may not have a unique identifier in the database, which brings problems to choosing the primary...

In this article, we will learn to update multiple columns with different values ​​in multiple rows in MySQL using CASE statement, IF() function, INSERT ... ON DUPLICATE KEY UPDATE clause and function. UPDATE with JOIN() Update multiple...