MySQL Tools

MySQL JOINs Tutorial with Examples

The article presents a detailed tutorial on MySQL JOINs. In it, you will learn about different types of JOINS that are supported in MySQL, their syntax, and how to use them.

(more…)

How to Rename a MySQL Database

Eventually, it appears necessary to change the name of a database in MySQL. For that purpose, we used to apply a simple RENAME DATABASE command that existed in earlier versions of MySQL. However, it became no longer available in the newer versions as it posed risks. The reason was that the RENAME DATABASE query could result in the loss of essential database contents, which clearly was undesirable.

(more…)

MySQL SELECT Statement Basics

The article covers the basic syntax of a MySQL SELECT statement and provides examples that show how to use a MySQL SELECT statement to retrieve data from tables.

(more…)

MySQL INSERT Statement – Inserting Row Into a Table

The article covers the basic syntax of the MySQL INSERT statements and explains how to use the INSERT command in the MySQL table using dbForge Studio for MySQL.

(more…)

MariaDB Tutorial: An Introductory Guide with Examples

MariaDB is a popular relational database management system (RDBMS) that has a striking resemblance to MySQL. That is why we decided to compare and contrast the two systems while maintaining the focus on MariaDB databases. Read on to discover the essential information on MariaDB and learn how to install and connect to your MariaDB database as well as execute simple queries.

(more…)

Introduction to MySQL UPDATE Statement

Most modern websites and applications ground on data collection, storage, and analysis. Databases take an active part in building the entire Web environment. That’s why it is crucial to ensure correct data retrieval from databases and appropriate ways of data manipulation. To modify your data properly, you will need to execute SQL queries. The current article will focus on the MySQL UPDATE statement and its use.

(more…)

How to Connect to MySQL Server

In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server.

(more…)

New Connectivity Options in dbForge Fusion for MySQL, v6.6

We are glad to inform our MySQL users, that a new version of our Visual Studio plugin for MySQL database development, dbForge Fusion for MySQL, v.6.6, has been just rolled out.

(more…)

What is MySQL: The Essence and the Features

Introduction to Relational Databases

Collecting, storing, and processing data are the primary tasks of today. As the data grow, the question of handling them becomes painful. In many cases, the most efficient solution is a relational database – an organized collection of data stored in tables that relate to others. It is optimal for extensive volumes of data.

(more…)

How to View MySQL Server Log Files

Sooner or later, every developer and DBA faces the necessity to find out the reasons for slow database performance. This article will take a detailed look at how to set up MySQL Server logging, what types of MySQL Server logs exist, and how to work with them.

(more…)