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 understand the concept of substring_index function in MySQL. Such a concept allows the user to get a string of his choice from an array of different strings. Let's take a closer look at this function. SUBSTRING_INDEX...

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

If you don’t know how to store passwords in MySQL database, then this is the right place. In this guide, you will be able to learn about how to store hashed passwords in MySQL database, different techniques and their specific methods used...

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

Sometimes we may need to delete single or multiple columns from a database table. ALTER TABLE DROP COLUMN The command statement in MySQL can delete a column from a table. Here is the common syntax to accomplish this: ALTER TABLE table_name...

In this article, we aim to explore how to check the current version of MySQL on macOS. Checking MySQL version in macOS When trying to figure out the version, you must follow these steps. Each time a person logs into the MySQL server, the ve...

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

This article aims to explore how to perform a full join or full outer join in MySQL. Full outer join is used to merge or combine the entire data from two separate tables. For example, suppose we have two tables named student_id and student_...

In this article, we will learn how to get the current version of MySQL on Windows systems. It is necessary for businesses to maintain versions of different tools and software used to run their business in order to keep systems compatible. T...

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

This article describes how to use SQL query to obtain the data records of the last 30 days from the database. Import data into the database First, let's import some sample data into the database using SQL query. Before we import the dataset...

Today, we will learn the DATE(), CAST(), CONVERT() and DATE_FORMAT() methods to convert DATETIME type to DATE type in MySQL. The above mentioned methods can be used in MySQL 4.0 and above. Converting from DATETIME to DATE in MySQL To unders...

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