How to SHOW or LIST Tables in MySQL
There are two primary methods to view the tables in MySQL: In this article, we are going to explore...
ENUM (Enumeration) Data Type in MySQL: Top 12 Facts and Useful Tips
MySQL ENUM data is a string data type with a value chosen from the list of permitted values. You set these permitted values during the...
How to Protect MySQL Databases from Ransomware Campaigns
MySQL is known for being easy to use and highly secure. That’s why it is the number one choice for many organizations, including the...
How to Delete Entire MySQL Database
In some cases, we need to drop the entire database from the MySQL community server. This is simple...
MySQL UPDATE: Top 5 Tips for T-SQL Developers
Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the commands you need to learn. We are...
Successful MySQL/MariaDB Backup and Recovery Strategies
A vital part of preventing any kind of data loss in any situation is having appropriate backup and recovery policies. It is also essential...
9 Best Practices for Writing SQL Queries
If you are reading this article, most probably, you are already familiar with SQL. You know how to...
TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers
Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are proceeding to the MySQL DELETE statement....
How to install MySQL Server on Ubuntu 18.04 in 2 Different Ways
This article will present the step-by-step installation process of the MySQL server on Ubuntu. For demonstration purposes, I created a...
Backup and Restore MySQL Database Using mysqldump
The current article focuses on applying the mysqldump utility to backup and restore MySQL...
