MySQL

How-tos How to Find Value in a Set in MySQL Database This tutorial demonstrates how to check the occurrence of a value or find a value in a set in a MySQL database. ↗ How-tos How to Calculate Average of a Table Column in MySQL This tutorial demonstrates how to calculate the average of a column in MySQL. ↗ How-tos How to Select Multiple Values Using WHERE in MySQL This article will discuss using the WHERE clause in SQL queries. Moreover, it will discuss different methods for selecting multiple values using the WHERE clause. ↗ How-tos How to Use PHP MySQLi Function to Fetch Last Inserted ID This tutorial demonstrates how to fetch the last insert id from the MySQL database using PHP MySQLi function. ↗ How-tos How to Find Tables in MySQL With Specific Column Names in Them This tutorial demonstrates how to find tables from a schema with specific column names in MySQL. ↗ How-tos How to Convert Rows to Columns in MySQL This tutorial demonstrates how to convert or change rows to columns in 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 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 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 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 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. ↗