迹忆客 EN >

This article teaches you how to use MySQL VIEW and MERGE create table aliases. In both cases, changes in the original table are reflected in the alias table. Also, SELECT query results on the alias table and the original table will be the s...

Today, we will understand the difference between the WHERE and clauses in MySQL . We will understand these clauses individually with code examples and compare them in a tabular form to highlight the differences. HAVING In WHERE MySQL HAVING...

Sometimes we may need to delete single or multiple columns from a database table. ALTER TABLE DROP COLUMN The command statement in MySQL can delete a column from a table. Here is the common syntax to accomplish this: ALTER TABLE table_name...

This article demonstrates several ways for users to delete all tables in MySQL and lists sample scripts to implement this method. The reason you can't just drop all the tables in one line of code is that in a large and well-designed databas...

In this article, we aim to understand how to use CASE WHEN statement in MySQL database. Businesses and organizations that process large amounts of data need to filter data based on specific conditions. If there are multiple conditions, it i...

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

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

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

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

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

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

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

This is a special function in PHP MySQLi that counts and returns the number of rows present in the result set. MySQLi Count() Rows Assume that we have the following dataset in a table named network. We want to count the number of rows in a...

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

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