MySQL

How-tos How to Convert Blob Data Into the Text Format in MySQL This article is a detailed guide about the blob datatypes in MySQL and its conversion into the non-binary format. ↗ How-tos How to Rebuild Index in MySQL This tutorial demonstrates how to rebuild indexes in MySQL. ↗ How-tos How to Drop a Column if It Exists in MySQL In today's post, we'll learn how to drop a column if it exists in MySQL. ↗ How-tos How to Add an Auto Increment Column in MySQL In today's post, we'll learn how to add an auto-increment column in MySQL. ↗ How-tos How to Specify Unique Constraints for Multiple Columns in MySQL In today's post, we'll look at many methods for specifying unique constraints for multiple columns in MySQL. ↗ How-tos How to Check if a Database Exists in MySQL In today's post, we'll learn how to check if a database exists in MySQL. ↗ How-tos How to Print to Console in MySQL In this article, we discuss how to print messages to the console in MySQL and how SELECT statement can be used to perform it. Mainly we discuss some uses cases to understand the … ↗ How-tos How to Split String Into Rows in MySQL In this article, we discuss what splitting string into rows is and how to create a self-executing function. Mainly we discuss the SUBSTRING_INDEX() method along with some examples … ↗ How-tos How to Show Locks in MySQL In today's post, we'll learn about how to show locks in MySQL. ↗ How-tos How to Get Last 30 Days Data in MySQL This article discusses how to get the last 30 days' data records using the SELECT method. We have used now(), data_sub(), curdate(), and between() commands. ↗ How-tos How to Connect to a MySQL Database Using JDBC This article discusses the JDBC and the requirements to connect a database with JDBC. We also looked at an example to see how we can implement a Java code to connect the MySQL … ↗ How-tos How to Create Cron Job in MySQL The main aim of this article is to demonstrate how to schedule a query written in MySQL and execute it after a fixed amount of time using Cron Jobs. ↗ How-tos How to Clear the Screen in MySQL The main aim of this topic is to demonstrate how to clear the screen of the MySQL console. We also have a look at how to clear console in the different operating systems. ↗ How-tos How to Update Record if It Exists Else Insert It in the MySQL Table In today's post, we'll learn how to update records in a MySQL table if exists, else insert them. ↗ How-tos MySQL COUNT IF Method This tutorial demonstrates how to use the COUNT IF method in a MySQL database. ↗ How-tos Minus Operation in MySQL This tutorial guides you about how can you emulate the MINUS operation in MySQL. It also teaches you various ways to simulate MINUS Operation with different examples. ↗ How-tos Different Ways to Connect a Remote MySQL Server Using Ubuntu This tutorial educates about different ways to connect a remote MySQL server using Ubuntu to start/stop service as well as to read/write data. ↗ How-tos MySQL SUBSTRING_INDEX In this guide, we will understand the concept of substring_index function in MySQL. ↗ How-tos Usage of IF EXISTS in MySQL Database This tutorial demonstrates how to use IF EXISTS in a MySQL database. ↗ How-tos Usage of UPDATE JOIN in MySQL This tutorial demonstrates how to use update join in a MySQL database. ↗ How-tos CASE WHEN in MySQL This tutorial is about using the CASE WHEN statement in a MySQL database. ↗ How-tos Substring in MySQL This guide will show the use of the substring of a particular column in MySQL. ↗ How-tos If ELSE in MySQL This tutorial demonstrates how to use IF ELSE statement in MySQL. ↗ How-tos Elastic Search in MySQL We will learn how to integrate ElasticSearch with MySQL. We will also examine a few key differences between JSON format databases and relational databases. ↗