mysql

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

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

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

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

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

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

How to Install MySQL on Windows Using MySQL Installer

The article provides a comprehensive walkthrough outlining the aspects of how to install MySQL Server on Windows using MySQL Installer. Learn the subtleties of the MySQL installation process step-by-step to ensure you have MySQL Server together with its tools running smoothly.

(more…)

What is MySQL: The Essence and the Features

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

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

dbForge Studio for MySQL vs MySQL Workbench

Every single year new products and new versions of the leading tools enter the market. Their providers compete, offering database specialists more and more features. Thus, users have a whole bunch of possibilities to achieve their goals with the best-fit solutions. The only challenge remaining is which tool to use.  (more…)