JIYIK CN >

In this article we will learn how to use FOREIGN_KEY_CHECKS in MySQL Workbench to temporarily turn off foreign key constraints in MySQL. Disable foreign key constraints in MySQL There are many situations where we temporarily turn off foreig...

This article highlights various ways to get a history of MySQL commands we have executed in Windows and Linux. MySQL Command History We will use Windows and Linux (Ubuntu 20.04) operating systems to understand different ways to get MySQL co...

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

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

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

In this article, we will learn how to sum multiple columns in MySQL. Sum multiple columns in MySQL You can use aggregate functions SUM() to calculate the total value in a collection. SUM() The function calculation does not consider NULL val...

In this article, we will introduce many ways to check if a database exists in MySQL. Check if the database exists in MySQL The system schema is the schema that MySQL uses. It includes tables that contain data needed by a running MySQL serve...

In this article, we will learn about various ways to sort data alphabetically in MySQL. Sort MySQL data alphabetically When you use the SELECT command to query data from a table, the rows in the result set are in arbitrary order. To order t...

In this article, we will learn how to find the difference between two tables in MySQL. The difference between two tables in MySQL We often need to compare two tables to find records in one table that have no matching records in the other ta...

Today, we will learn how to TIMESTAMP insert date and time into a type column of a MySQL table according to the table definition. Create a MySQL table First, we will create the tables that we will use in this tutorial. Sample code: CREATE T...

Today, we will explore three scenarios and their solutions where we want to select the first row from a MySQL table. In the first scenario, we will learn to get the first row from a MySQL table where there are multiple instances of a partic...

Today, we will learn about queries in MySQL that can display the table and database structure. We will use the mysqldump utility, DESCRIBE the , SHOW TABLES and SHOW CREATE TABLE the statements. We are using MySQL version 8.0.28 while writi...