MySQL

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 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 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 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. ↗ How-tos How to Round Down to the Nearest Integer in MySQL This tutorial demonstrates how to round down to the nearest integer in a MySQL database. ↗ How-tos How to Replace a String in MySQL This tutorial demonstrates how to replace a string in a MySQL database. ↗ How-tos How to Load Data INFILE in MySQL This tutorial demonstrates how to import data from CSV using data INFILE in MySQL database. ↗ How-tos How to Get Column Names in MySQL This tutorial demonstrates how to get all the column names in a MySQL database. ↗