MySQL

Uninstalling MySQL can sometimes be the solution for dealing with bugs, or when you need to shift back to an older version. This tutorial shows how to uninstall MySQL on Windows, Linux, and macOS.

With Structured Query Language (SQL), you can easily access and manage content in all your databases. This guide will show you how to list all MySQL Databases.

Database relationships are an important concept in database modeling. Learn about the different relationship types and how they are created in this article.

The SHOW TRIGGERS statement in MySQL helps provide a detailed overview of created triggers in a database. Learn how to use the statement effectively in this guide.

The mysql_secure_installation script allows you to significantly improve MySQL server security. Follow this guide to learn more about the script and the options it accepts.

Databases and tables that reside in them grow in size. Follow this tutorial to see three different methods to check the size for a single table, database, all tables and all databases.

MySQL string functions allow you to manipulate character string data using the SELECT statement. Learn to use MySQL string functions with this comprehensive tutorial.

A corrupt database can happen at any moment. Try some of these methods to repair your MySQL database quickly.

Spark contains three major data structures and APIs for working with big data: RDDs, DataFrames and Datasets. Learn about the difference between them as well as when it's best to apply each.

MySQL tables fragment over time as delete and update queries are performed. With a large database, the fragmentation slows down queries significantly. Learn about when to use optimization and follow our tips on how to perform table defragmentation.