MySQL Tools

What Is InnoDB in MySQL? Tutorial with Examples and Performance Tuning Tips

There is a number of powerful MySQL storage engines at our disposal, and InnoDB is undoubtedly one of the most popular ones. It is highly reliable and efficient, so it is no wonder that it has become a default storage engine for all MySQL versions from 5.5 on. Let us take a look at its advantages and features more closely.

(more…)

dbForge Studio Shortlisted by Capterra and Awarded Front Runners 2021 by Software Advice

dbForge Studio is a product line designed to encompass every aspect of database development and administration, providing versatile functionality in a single IDE. It is available for all major database management systems: SQL Server, MySQL, Oracle, and PostgreSQL. One of the ways to evaluate its hard-earned reputation is to get acquainted with its accolades — and two of them are the subject of our today’s story.

(more…)

How to Create a View in MySQL

This article will show you how to create and manage views in MySQL. A view is a virtual table that does not store its own data but rather displays data that is stored in other tables. Essentially, a view is a result of SQL query execution, which returns the required rows of data from one or multiple tables.

(more…)

Debug Easily in Visual Studio Using dbForge Fusion Plugin Debugger

The article presents a detailed overview of the Code Debugger functionality that comes with dbForge Fusion for MySQL – a powerful MySQL development add-in for Visual Studio.

(more…)

MySQL for Visual Studio vs dbForge Fusion for MySQL: A Comparison of Plugins

Microsoft Visual Studio plugins continuously compete to empower users with extended capabilities. Free tools have the most obvious advantage — while you don’t have to pay for them, they tend to deliver all the essentials to cover your basic needs. Paid tools mean broader functionality, convenience, and customization, but the bottom line is whether the value you get surpasses the price.

(more…)

Storage Engines in MySQL

This article focuses on the database storage engines for MySQL that ensure appropriate performance and manage SQL operations for multiple table types. The article examines the differences between the most widely used MySQL storage engines.

(more…)

How to Create a New User Account in MySQL and Grant Permissions on a Database

This article provides a complete overview of how to create a new user account in MySQL and grant different types of privileges on a MySQL database. Learn the basics of user account management and find hints.

(more…)

Creating a New Database in MySQL: Tutorial with Examples

The article provides a detailed overview of how to create a database in MySQL using different methods and tools (including the Command Line, Workbench, and dbForge Studio for MySQL).

(more…)

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