JIYIK CN >

Keywords in any programming language such as C, C++, Java, and MySQL are useful; they are called reserved words. These reserved words have meanings and functions. When these keywords are used in a statement, they operate according to their...

This article will teach you how to use mysqli_real_escape_string to process form data. First, we will set up a sample database and a table. Then we will create an HTML form that accepts user input. After that, in PHP, we will explain how to...

In this tutorial, we aim to understand how to use the command with two or more columns GROUP BY . MySQL GROUP BY command is a technique by which we can group records having same values ​​together based on a specific criteria defined for...

In this tutorial, we will learn about MySQL WITH CONSTRUCTED TE clauses, also known as Common Table Expression (CTE). CTE is used whenever you want to manipulate data with difficult subqueries. We will also learn Common Table Expression how...

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

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

In this article we will understand the uses, advantages and alternatives of ZEROFILL attribute in MySQL. Use and benefits of the ZEROFILL attribute in MySQL The benefit of using the ZEROFILL attribute is that it has nothing to do with input...

This tutorial article will show you how to use MySQL JOIN methods to delete data from multiple tables. This is useful when you are simultaneously deleting records from one table that are related to a specific record in another table. DELETE...