How to Make the Best Use of Comment Function in MySQL
Comments are used to add information to the code. It is mostly ignored by the compiler, but human...
Different Ways to View Tables in MySQL Server
There are two primary methods to view the tables in MySQL: The MYSQL SHOW TABLES command. Querying the Information_schema.tables table. In...
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...
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...
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. Open the Azure portal and log in using...
MySQL Insert Command vs T-SQL Query Syntax with Examples
Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If you’re coming from the T-SQL camp,...
ODBC Driver for MySQL: How to Install and Set up Connection (Step-by-step)
This article focuses on the step-by-step processes of installing and configuring the ODBC driver...