JIYIK CN >

This tutorial is an exhaustive guide on how to optimize tables and databases in MySQL. We will be using two operating systems, Windows and Linux (Ubuntu 20.04). It also introduces the importance of optimization in MySQL. When and Why to Opt...

This article will show you how to retrieve the number of records in a MySQL table. We will also show you how to apply conditions to count the rows that meet a certain criteria. Count all rows in a MySQL table To retrieve the count of record...

This article aims to understand how to delete multiple tables in MySQL. Most businesses and organizations that use MySQL to visualize and analyze data have multiple tables to work with. Sometimes, these tables become redundant. In such case...

This article will explain how to rename a table in a MySQL database. Often, an organization's product requirements change, and as a result, the names of tables and columns in a particular database need to be constantly changed. These change...

This article will show you how to send data from an HTML form to a table in a database. To do this, we will use the following steps: First, we'll create a basic HTML form to collect data. We will then use POST the method to send the data fr...

In this article, we will learn how to find error logs in MySQL database. Businesses and organizations must have access to error files in MySQL as it helps them to evolve and strengthen their database management system through efficient quer...

In this article, we aim to explore different ways to check the strings contained in a MySQL table. We will introduce the following technologies in MySQL. INSTR function LOCATE function LIKE Operators Before we get started, however, we creat...

The purpose of this article is to explore different ways to create a copy of a table in MySQL. The source table is also called the table to be copied, and the target table is called the clone table, which can be from the same or a different...

This article provides several options to check if a table exists in MySQL. Before discussing it, let us first see what a table is in MySQL and when you need to check its existence. What is a table in MySQL? A table is a database object that...

This article highlights different ways to check if a row exists in a MySQL table. We will use the EXISTS and NOT EXISTS operators. We can also use these two operators with IF() the function to get a meaningful message if a row (a record) is...

Today I will show you how to truncate all tables in Mysql. It is used when you want to delete the entire table TRUNCATE TABLE . TRUNCATE It is a type of DML statement, which means it cannot be rolled back once it is committed. There are two...

In this article, we aim to explore different ways to create temporary tables in MySQL. One of the main features of temporary tables is that it helps in storing temporary data. This feature is enabled in MySQL 3.23 and later versions. These...

In this article, we aim to understand how to create a table from CSV in MySQL database. Businesses and organizations must quickly generate tables from large amounts of data. These organizations typically have large CSV files with large amou...

This article explains how to use MySQL to query from multiple tables in one script SELECT . Let's demonstrate a situation: SELECT name , price, details, type , FROM food, food_order WHERE breakfast.id = 'breakfast_id' Now, let's imagine FRO...

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