Tag: mysql

How to Change Default MySQL Port in Windows 10

SQL Server

A network port is a communication endpoint used by applications, incoming connections, and external...
Read More

How to Comment MySQL Code: Best Practices

Database development, Statements

Comments are used to add information to the code. It is mostly ignored by the compiler, but human specialists can read those comments when...
Read More

How to SHOW or LIST Tables in MySQL

Database development, Tables

There are two primary methods to view the tables in MySQL: The MYSQL SHOW TABLES command. Querying the Information_schema.tables table. In...
Read More

MySQL UPDATE: Top 5 Tips for T-SQL Developers

Database development, Languages & Coding, Statements, T-SQL

Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the...
Read More

Successful MySQL/MariaDB Backup and Recovery Strategies

Database administation

A vital part of preventing any kind of data loss in any situation is having appropriate backup and recovery policies. It is also essential...
Read More

TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers

Database development, Languages & Coding, Statements, T-SQL

Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are proceeding to the MySQL DELETE statement....
Read More

How to install MySQL Server on Ubuntu 18.04 in 2 Different Ways

Tools & technologies

This article will present the step-by-step installation process of the MySQL server on Ubuntu. For...
Read More

Backup and Restore MySQL Database Using mysqldump

Tools & technologies, Utilities & Extensions

The current article focuses on applying the mysqldump utility to backup and restore MySQL databases. This utility is the most common tool...
Read More

How to Create and Deploy Azure Database for MySQL Server using Azure Portal and Workbench

Azure, Cloud, Database development

This article describes the step-by-step deployment process of the Azure Database for MySQL Server. Open the Azure portal and log in using...
Read More

MySQL Insert Command vs T-SQL Query Syntax with Examples

Database development, Languages & Coding, Statements, T-SQL

Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If...
Read More
Close