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...
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 but irreversible. Thus, the DROP...
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...
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 write basic SQL queries. There are many...
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...
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 databases. This utility is the most common tool...
How to Create and Deploy Azure Database for MySQL Server using Azure Portal and Workbench
This article describes the step-by-step deployment process of the Azure Database for MySQL Server....
