Menu

Practical solutions

MySQL Howtos How-To Guides

Solve the problem. Keep building. Collection of MySQL how-to articles

Find the answer you need

Browse practical solutions, grouped by the task you're working on.

__COUNT__ entries on this page

MySQL RestoreHow to Restore Database From SQL File in MySQLThis tutorial demonstrates how to restore the database from sql file in MySQL.

MySQL PermissionHow to Create Read-Only User in MySQLThis 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 or read by the user, but neither the data nor the database's structure can be altered by the user.

MySQL BackupHow to Backup a Single Table Using MysqldumpThis article discusses using mysqldump to back up a single table in MySQL using the cmd.

MySQL SynchronizationHow to Synchronize MySQL DatabaseThe aim of this article is to demonstrate how to achieve database synchronization for backup and record-keeping purposes.

MySQL XAMPPHow to Access MySQL Command Line With XAMPPWe 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.

MySQL PasswordHow to Store Password in MySQL DatabaseIn 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.

MySQL RecursiveMySQL Recursive QueryIn this guide, we will learn about the recursive query in MySQL.

MySQL QueryHow to Check if String Contains Certain Data in MySQLThis tutorial demonstrates how to check whether a string contains a certain data or substring in a MySQL table.

MySQL QueryHow to Select All Tables in MySQLThis tutorial demonstrates how to select all the tables in a MySQL database.

MySQL TableHow to SELECT From Multiple Tables in MySQLThis article demonstrates how to SELECT from multiple tables in SQL and have it unique per row

MySQLHow to Store Arrays in MySQLThis article demonstrates how to store arrays in MySQL.

MySQLHow to Insert a Row if Not Exists in MySQLThis article demonstrates how to insert a row into a table if it doesn't exist yet in mySQL

MySQL TableHow to Drop All Tables in MySQLIt demonstrates how to drop all tables in SQL

MySQL ImportHow to Import a CSV File Into a Table in a MySQL DatabaseThere 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 an interactive MySQL client such as HeidiSQL.

MySQL QueryHow to Rename a Column in MySQL DatabaseThis tutorial demonstrates how to rename a column in a MySQL database.

MySQL TableHow to Pivot Table in MySQLThis article demonstrates different ways of generating Pivot table in MySQL.

MySQLHow to Delete Duplicate Rows in MySQLThis article demonstrates delete duplicate rows in MySQL.

MySQL TableHow to Create a Temporary Table in MySQLThis tutorial demonstrates how to create a temporary table in a MySQL database.

MySQLHow to Count Distinct Values in MySQLThis tutorial demonstrates how to count distinct values in a MySQL database.

MySQLHow to Compare Two Dates in MySQLThis article demonstrates different way of Comparing Two Dates in MySQL.

SQL QueryHow to Use Boolean Data Type in MySQLThis tutorial demonstrates how to use boolean data type in SQL.

MySQL InsertHow to Insert Bulk Values in MySQLThis tutorial demonstrates how to insert bulk values in MySQL.

MySQL GroupbyHow to Group by Multiple Columns in MySQLThis tutorial demonstrates how to group by multiple columns in MySQL.

MySQL JoinHow to Execute Multiple Joins in One Query in MYSQLThis 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.