Databases

PostgreSQL Drop Database with Examples

July 11, 2024

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

Read more

How to Convert MyISAM to InnoDB

July 10, 2024

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.

Read more

MySQL DROP TABLE Statement

July 4, 2024

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.

Read more

MyISAM vs. InnoDB: Differences Explained


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.

Read more

How to Allow MySQL Remote Connections


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

Read more

How to Create a Table in Hive

June 27, 2024

Apache Hive is a data warehousing tool used to perform queries and analyze structured data in Apache Hadoop. Use this clear-cut tutorial to learn how to create tables in Hive.

Read more

How to Delete Duplicate Rows in MySQL

June 20, 2024

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.

Read more

MySQL Index: Usage, Management & Troubleshooting

June 18, 2024

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.

Read more

How to Import a CSV File into a MySQL Table

June 6, 2024

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.

Read more

How to Connect to MySQL from Command Line in Windows

June 5, 2024

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.

Read more
1 2 3 15