JIYIK CN >

This article shows you how to use and create a simple function in MySQL. 函数 What is in MySQL In the MySQL programming language, 函数 a set of statements that executes a set of rows and returns a value. When the function block is calle...

The SQL datepart function extracts a part of the datetime data type and is used to filter or aggregate table fields in SQL databases. However, it is not directly available in MySQL. Datepart Function alternatives in MySQL datepart There are...

We will learn the best way to delete all rows in a database using DELETE. We will explore phpMyAdmin the command to delete rows from a given table. MySQL DELETE We will also learn the difference between the DELETE , , DROP and TRUNCATE comm...

In MySQL parlance, a constraint is a set of rules enforced on a table to prevent certain anomalies. These exceptions will result in error records in the table. Constraints can be of various types based on the behavior of the failure. They a...

This article will introduce transactions and stored procedures for inserting into multiple tables in MySQL. Inserting into multiple tables in MySQL It is not possible to insert into multiple tables with a single MySQL command, but we can us...

This article uses the GROUP BY clause, COUNT() and DATE() functions to group DATETIME type columns by DATE only in MySQL. Use GROUP BY, COUNT(), and DATE() in MySQL to group a DATETIME column by DATE only Before we proceed, remember that DA...

This article introduces the DECIMAL(P,D) data type which is best suited for storing monetary values ​​in MySQL. MySQL currency data type Monetary values ​​need to be represented accurately. We don't need to use only approximate data...

In this article, we will learn about NOW(), CURRENT_TIMESTAMP() (also written as CURRENT_TIMESTAMP), and SYSDATE() to get the current date and time in MySQL. We will also see a comparison between these three functions. Get the current date...

Sometimes, we may need to convert one data type to another. Here is how we can DECIMAL(M,D) convert to decimal in MySQL using CAST() and CONVERT() functions with . Using CAST() with the DECIMAL(M,D) function to convert to decimal in MySQL W...

MySQL is an abbreviation for Structured Query Language which is a relational database management system. It is an open source database which is freely available and used for both large and small applications. The use cases are in school app...

In this article we will learn how to connect to a remote MySQL server using Ubuntu to manipulate data and start and stop the MySQL server. Different ways to connect to a remote MySQL server using Ubuntu Data operations from Ubuntu 20.04 cli...

This article presents three alternative implementations that we can use as the equivalent of Oracle's decode() function in MySQL. To do this, we will use IF(), CASE, and a combination of FIELD() and ELT(). MySQL equivalent of Oracle's decod...

This article explains how to update the primary key in a MySQL table. We will use the ALTER command to make any changes to the primary key. Update the primary key in a MySQL table We can update the primary key in a MySQL table in multiple s...

This article will explain how to use mysqldump to back up only the data. Here we will explore the --no-create-info , --compact , , --skip-triggers and --no-create-db options. If you are planning to back up single or multiple databases and t...

This article introduces three ways to list all stored procedures in MySQL. They include the SHOW PROCEDURE STATUS statement, the data directory, and MySQL Workbench (a visual tool). List all stored procedures in MySQL We will use the data d...