迹忆客 EN >

Full-text search is a database technology that retrieves records even if they do not exactly match our search criteria. This enables rich, natural language searches that feel more familiar. Using full text search to search for "database eng...

Skeema Is an open source CLI tool that allows us to synchronize MySQL database schemas across multiple hosts. It works on plain SQL files containing CREATE TABLE statements. Database migration is one of the most common challenges during sof...

This is a very naive post, and the only reason for writing it is so that I won't forget the syntax and have to Google MySQL REPLACE the order of the arguments to the _ function again. And then when I try to look it up, I almost always end u...

In this article, we will explore how to perform CRUD (Create, Read, Update, and Delete) operations using a MySQL database with PHP. If you want to get hands-on experience with database connections in PHP, this article is a good starting poi...

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

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

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

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

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

In this article, we aim to explore different ways to rename columns in MySQL. ALTER TABLE The command is mainly used to change the format of a given MySQL table. It can be used to add columns, change the data type within a column, delete co...

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

In this article, we aim to explore how to get the column names of a specific table in MySQL database. Often, when working with data in MySQL, we tend to forget the column names of a particular table in the database and the data types of dif...

In this article, we aim to explore the concept of finding entries in a table in MySQL based on conditions associated with dates. Most of the businesses and organizations using MySQL for data analysis or visualization need to sort or fetch d...

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