mysql tools

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

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

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

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 We Made More Realistic Tests with dbForge Data Generator for MySQL

We have been developing our own SaaS CMS platform floowedit since 2007. During all the development and improvement phases we have always faced a problem: having realistic and quantitative test data at hand. In fact, like everyone else, we use dummy data generators and often work with so-called ‘lorem ipsum’.

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

Devart Becomes the Winner of 2020 CV Magazine Technology Innovator Awards

For more than 15 years, Devart has been developing database tools and data-related solutions. One of its most popular product lines, dbForge, is designed to facilitate and simplify database development, management, and administration for SQL Server, MySQL, Oracle, and PostgreSQL.

(more…)

Top 10 Reasons Why Users Choose dbForge Studio for MySQL

The overwhelming popularity of MySQL means that people need convenient database tools to work with it. Software providers compete to produce the best MySQL client. However, the goal is not to develop a ton of options and thrust them all into one solution. It is to make a complete product that would match any user’s needs and suit both the basic operations and the most sophisticated and challenging tasks.

(more…)