MySQL

Learn how to find the duplicate entries in your MySQL databases. The guide shows three different ways to find duplicates in a MySQL table.

This article explores several highly efficient methods that allow you to export a MySQL table as a CSV file. As a CSV file, the data from your tables becomes much more accessible, both to humans and a host of other applications.

This article explains how to create a new MySQL non-root user and grant various types of privileges.

InnoDB is the default storage engine for modern MySQL database tables. Learn how to check a table's storage engine and how to convert tables from MyISAM to InnoDB in this guide.

The DROP statement is a simple method to remove entire tables from your databases. It provides several versatile options that allow you to automate specific tasks. This tutorial also shows how to create a custom piece of code to remove tables based on character strings.

This guide explains how to modify settings in the MySQL configuration file on the remote server and enable remote connections.

When adding data to a MySQL database, you may end up with duplicate rows. This article shows you how to find these instances and delete duplicate rows in MySQL.

An index is an integral part of MySQL, helping with organizing and searching information more easily. This guide explains how to add an index to new and existing tables, as well as how you can display an existing index.

The article explains how to import a CSV file into a MySQL database using the command line or phpMyAdmin. Also, find out how to exclude the header row from the CSV and speed up the importation process.

MySQL is a popular and open-source relational database application. This guide will walk you through using the Windows Command prompt to connect to a MySQL database.