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

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

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

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

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

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