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

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

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 briefly introduces the PHP mysqli() function and demonstrates how to use it to get the last inserted ID from a MySQL database. PHP mysqli() Function It is an extended version of the MySQL driver called mysqli and is typically u...

This article describes possible causes and solutions for the MySQL error Data is truncated for a column . Fix data truncated due to column error in MySQL Here, we will discuss the possible causes and solutions to eliminate MySQL data trunca...

We are learning how to change the connection timeout in MySQL using Linux (Ubuntu 20.04) and Windows operating systems. Changing the connection timeout in MySQL Sometimes you keep losing connection to the MySQL server because the connect_ti...

This article is about using MySQL query to get data from a specific table or relation that satisfies a specific condition. To do this, the WHERE clause is used in the SQL query. WHERE clause in SQL query WHERE The clause specifies the condi...

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 article explains how to change the max_allowed_packet size in MySQL server. To understand this, we will use two operating systems, Windows 10 and Linux (Ubuntu). Changing max_allowed_packet Size in MySQL Server If we try to upload a fi...