JIYIK CN >

This article will show you how to send data from an HTML form to a table in a database. To do this, we will use the following steps: First, we'll create a basic HTML form to collect data. We will then use POST the method to send the data fr...

This article highlights different ways to check if a row exists in a MySQL table. We will use the EXISTS and NOT EXISTS operators. We can also use these two operators with IF() the function to get a meaningful message if a row (a record) is...

Today I will show you how to truncate all tables in Mysql. It is used when you want to delete the entire table TRUNCATE TABLE . TRUNCATE It is a type of DML statement, which means it cannot be rolled back once it is committed. There are two...

In this article, we aim to understand how to create a table from CSV in MySQL database. Businesses and organizations must quickly generate tables from large amounts of data. These organizations typically have large CSV files with large amou...

This quick tutorial will discuss backing up a MySQL database and saving it in a file as a script. When working with a database, it is recommended to back up the database regularly. This is because some problematic situations may arise durin...

This tutorial explains three methods named LAST_INSERT_ID() , , MAX() and through code examples ORDER BY DESC and demonstrates how to get the ID of the most recently inserted record in MySQL. Get the ID of the most recently inserted record...

In this guide, we will understand the concept of substring_index function in MySQL. Such a concept allows the user to get a string of his choice from an array of different strings. Let's take a closer look at this function. SUBSTRING_INDEX...

In this guide, we will learn about recursive queries in MySQL. How to write recursive queries in SQL and how it works will be explained in this guide for your better understanding. MySQL recursive query A recursive query in SQL is a subquer...

Wamp server allows for the creation of web applications, while PhpMyAdmin allows for database management. This guide will teach you how to set up your Wamp server MySQL username and password. Wamp Default MySQL Password Open the Wamp deskto...

Want to convert your string to lowercase, but don't know how to do it efficiently? We've got you covered. MySQL convert string to lower case The trick is that MySQL provides a function, namely LCASE() , or Lower() . Both of these can be use...

If you don’t know how to store passwords in MySQL database, then this is the right place. In this guide, you will be able to learn about how to store hashed passwords in MySQL database, different techniques and their specific methods used...

A database administrator may occasionally need to add a record to a MySQL table, or update a frequently occurring record. MySQL will send an alert if a user attempts to insert a record that already exists or has a duplicate PRIMARY KEY valu...

We will learn how to integrate ElasticSearch with MySQL. We will also look at some of the key differences between JSON format databases and relational databases. Integrating ElasticSearch with MySQL As we all know, MySQL is a relational-bas...

The main purpose of this topic is to demonstrate how to clear the MySQL console screen. Clearing the Screen in MySQL When working on the MySQL Console and managing configuration and data, the screen can become overly cluttered with the resu...

This article will discuss how to print messages or data to the console in MySQL. MySQL prints to the console When using MySQL database, we often need to print some data or messages to the console. MySQL can use the SELECT command to accompl...