I feel kinda silly here. I realize that I’ve never made a while loop in MySQL or MariaDB. Now that I’m actually trying to do it, it’s proving to be quite the task. Normally I would do all of ...

The fact that MySQL's standard administrative tool is based off the command line, however, does not mean that it is complicated or difficult to use. Inserting a string into a MySQL table is a ...

This is likely because when I first learned it was with command-line tools, but even so, I think command-line database tools often are the best way to interact with a database manually. Two of the ...

This article shows you how to set, change, and recover secure passwords for your MySQL root account, so you'll never be at a loss.

DBeaver is a free, universal SQL client that can connect to numerous types of databases–one of which is MySQL. I want to show you how to install and use DBeaver to connect to your remote MySQL ...

This ad hoc sorting functionality saves many keystrokes when compared to the MySQL command line client. Any SQL command can be executed in the query input field—not just queries. And the commands ...