dbForge Studio for MySQL

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…)

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 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…)

dbForge Studio for MySQL Gains More User Recognition with 3 Prestigious Awards

dbForge Studio for MySQL is one of the most famous and valuable Devart products – a comprehensive solution with an intuitive interface for MySQL and MariaDB database developers, administrators, and managers. This product is a user favorite when it comes to creating and executing queries, developing and debugging procedures, and managing database objects.

The recognition comes with 3 brand new awards that we were happy and proud to receive from the leading industry platforms.

(more…)

How to Change a Column Name in MySQL

Learn how to safely rename a column in a MySQL database using a universal multi-featured tool – dbForge Studio for MySQL.

(more…)

Azure Database for MySQL: How to Connect and Migrate Databases with dbForge Studio for MySQL

In this article, you’ll learn how to connect to Azure Database for MySQL and discover three scenarios of database migration from MySQL to Azure using dbForge Studio for MySQL.

(more…)

How dbForge Studio for MySQL is Involved in the DevOps Process

When developing a software application based upon complex database structure, it is often necessary to run diverse business logic test scenarios on the same input data. That’s where the problem of repeated recovery of test data arises. This article offers the simplest way to automate the process using only one tool – dbForge Studio for MySQL.

(more…)