MySQL

How-tos How to Create Read-Only User in MySQL This article mainly discusses how to create the read-only user in MySQL. You need to make a user who can only access a database in read-only mode. The database's data can be seen … ↗ How-tos How to Backup a Single Table Using Mysqldump This article discusses using mysqldump to back up a single table in MySQL using the cmd. ↗ How-tos How to Synchronize MySQL Database The aim of this article is to demonstrate how to achieve database synchronization for backup and record-keeping purposes. ↗ How-tos How to Access MySQL Command Line With XAMPP We will learn how to run MySQL on command line with the XAMPP server. We will also learn how to create and import a database in an existing database from the command line. ↗ How-tos How to Store Password in MySQL Database In this guide, you'll be able to learn how to store hash password in MySQL database, the different techniques and their specific methods used for storing the Hash password. ↗ How-tos MySQL Recursive Query In this guide, we will learn about the recursive query in MySQL. ↗ How-tos How to Check if String Contains Certain Data in MySQL This tutorial demonstrates how to check whether a string contains a certain data or substring in a MySQL table. ↗ How-tos How to Select All Tables in MySQL This tutorial demonstrates how to select all the tables in a MySQL database. ↗ How-tos How to SELECT From Multiple Tables in MySQL This article demonstrates how to SELECT from multiple tables in SQL and have it unique per row ↗ How-tos How to Store Arrays in MySQL This article demonstrates how to store arrays in MySQL. ↗ How-tos How to Insert a Row if Not Exists in MySQL This article demonstrates how to insert a row into a table if it doesn't exist yet in mySQL ↗ How-tos How to Import a CSV File Into a Table in a MySQL Database There are two ways to import data from a comma-separated values file into a MySQL database. The first method is to do it programmatically with SQL commands, and the other is using … ↗ How-tos How to Rename a Column in MySQL Database This tutorial demonstrates how to rename a column in a MySQL database. ↗ How-tos How to Pivot Table in MySQL This article demonstrates different ways of generating Pivot table in MySQL. ↗ How-tos How to Delete Duplicate Rows in MySQL This article demonstrates delete duplicate rows in MySQL. ↗ How-tos How to Create a Temporary Table in MySQL This tutorial demonstrates how to create a temporary table in a MySQL database. ↗ How-tos How to Count Distinct Values in MySQL This tutorial demonstrates how to count distinct values in a MySQL database. ↗ How-tos How to Compare Two Dates in MySQL This article demonstrates different way of Comparing Two Dates in MySQL. ↗ How-tos How to Insert Bulk Values in MySQL This tutorial demonstrates how to insert bulk values in MySQL. ↗ How-tos How to Group by Multiple Columns in MySQL This tutorial demonstrates how to group by multiple columns in MySQL. ↗ How-tos How to Execute Multiple Joins in One Query in MYSQL This tutorial shows how to incorporate multiple joins in one query in MySQL; be it inner or outer ones. We also show different methods to define the join conditions. ↗ How-tos How to Copy a Table in MySQL This tutorial demonstrates how to create a copy of a table in a MySQL database. ↗ How-tos How to Use of Row_Number() Function in MySQL This tutorial teaches the way of making replica of SQL Server ROW_Number() Function in mysql. ↗ How-tos How to Rename a Table in MySQL This tutorial demonstrates how to rename a table in MySQL database. ↗