迹忆客 EN >

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

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

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

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

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

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

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

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

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

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

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

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 some cases, you must search for a string or substring in a table. For example, you want to know employee how many Gmail users there are in the table. Another example is employee to find all Je the names starting with in the table firstna...