迹忆客 EN >

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

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

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

In MySQL or any programming language, there are privileges to add constraints or checks in the instance of creating a table. These constraints help the user to restrict the values ​​inserted into specific fields of the table. The restri...

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

This article will explore the methods of specifying unique constraints for multiple columns in MySQL. Specifying unique constraints for multiple columns in MySQL You may sometimes want to guarantee that every value in a column or set of col...

In this article, we will learn about MySQL IDENTITY column. IDENTITY columns in MySQL While creating a table, we may not have a unique identifier in the database, which makes choosing a primary key challenging. To solve such a problem, we h...

Summary: in this tutorial, we will learn how to change rows to columns of a specific table in MySQL. Creating a Dataset in MySQL It is often necessary to get the appropriate information related to the necessary row data displayed as columns...

In this article, we will learn how to insert multiple rows in MySQL. Inserting multiple rows in MySQL INSERT adds new rows to an existing table. Use INSERT...VALUES the command to add rows based on explicitly provided values. INSERT privile...

MySQL stores data in columns and rows of tables, which users can define, control, manipulate, and query. MySQL provides us with various functions, and one function we can have is to split a string into rows. This article discusses splitting...

Sometimes we need to insert data in our database that is mostly similar to another row. In MySQL, there is a simple trick by which you can easily create duplicate rows. In this article, we will learn how to create a copy of a row in the sam...

In this article, we will learn how to display locks in MySQL. Displaying Locks in MySQL You can change the properties of a table by assigning a MySQL lock flag to the table. To restrict other sessions from accessing the same table for a cer...

This article explains how to find all tables with a specific column name in MySQL, but before that, you must understand the schema (database) in which these tables are stored. Let's start with that. Schemas in MySQL A database/schema specif...

In this article, we will learn how to delete single or multiple columns present in MySQL. If the column exists in MySQL, then delete the column In a table, a column is a row of cells that can contain text, numbers, and graphics. For each ro...