Tag: mysql

How to Make the Best Use of Comment Function in MySQL

13:00 Database development, Statements

Comments are used to add information to the code. It is mostly ignored by the compiler, but human...
Read More

Different Ways to View Tables in MySQL Server

10:54 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

10:48 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 commands you need to learn. We are...
Read More

Successful MySQL/MariaDB Backup and Recovery Strategies

16:32 Database administation

A vital part of preventing any kind of data loss in any situation is having appropriate backup and...
Read More

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

10:48 Tools & technologies

This article will present the step-by-step installation process of the MySQL server on Ubuntu. For demonstration purposes, I created a...
Read More

Backup and Restore MySQL Database Using mysqldump

16:38 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

16:26 Azure, Cloud, Database development

This article describes the step-by-step deployment process of the Azure Database for MySQL Server....
Read More

MySQL Insert Command vs T-SQL Query Syntax with Examples

15:55 Database development, Languages & Coding, Statements, T-SQL

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,...
Read More

ODBC Driver for MySQL: How to Install and Set up Connection (Step-by-step)

15:38 Tools & technologies

This article focuses on the step-by-step processes of installing and configuring the ODBC driver for MySQL. In particular, it will cover...
Read More

MySQL Create View, Replace View and Drop View Statements with Examples

17:15 Database development, Statements, Views

An SQL view is a virtual table or a result-set generated by the SELECT query. Unlike physical...
Read More