Databases

External tables in Hive are used to access and query data stored outside of a database. Follow the steps of this tutorial to learn how to create, query and drop external tables.

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

Create new MongoDB databases and add data collections by using the commands presented in this article. The use, insert and find commands are crucial tools that allow you to perform basic administrative tasks on your database servers.

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.

This tutorial teaches you how to remove (drop) a database in PostgreSQL using two different methods.

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.

Using the improper storage engine can lead to errors in querying and reduced speed and performance. In this article, you will learn differences between MyISAM and InnoDB storage engines. You will also learn how to check the storage engine and how it can be converted.

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