MySQL Tools

Devart Products Become the Winners of DBTA 2022 Readers’ Choice Awards

For the fourth year in a row, Devart solutions are voted winners of the Readers’ Choice Awards by the Database Trends and Applications magazine, which is one of the leading media focused on data science, big data, and information management.

(more…)

Erstellen von Tabellen mit dem MySQL CREATE TABLE-Befehl in dbForge Studio for MySQL

Es gibt zwei Arten, wie man Tabellen in MySQL-Datenbanken erstellen kann:

  • Ausführen einer Abfrage, die einen CREATE TABLE-Befehl enthält
  • Nutzung der entsprechenden Funktionen von MySQL-bezogenen Tools und IDEs
(more…)

How to Create a Table in MySQL

Creating tables is perhaps the most popular task in database development. In this article, we will review the ways of creating MySQL tables.

There are two main ways of creating tables in MySQL databases:

(more…)

MySQL CONCAT Function: How to Concatenate Strings in MySQL

The MySQL CONCAT function is widely used to concatenate multiple column values into a single column. In this article, we will look into the MySQL CONCAT() syntax, demonstrate to you how to use it, and explore the differences between CONCAT and CONCAT_WS.

(more…)

The Enhanced dbForge Tools for MySQL v9.1 Are Out!

Meet the long-awaited release of dbForge tools for MySQL. We have enhanced them with a few new features that will surely come in handy.  However, the foremost thing in this update is that our tools now can run on Linux and macOS through CrossOver, a solution that helps launch Windows applications on different operating systems.

(more…)

Meet dbForge Studio 2022 for MySQL – Now Available on Linux and macOS

We are happy to announce the new release of our flagship solution for MySQL – dbForge Studio for MySQL – which is now available on Linux and macOS! Check out the updated features and improvements.

(more…)

What Is a Database?

The article provides a general overview of the databases in simple terms, discusses their advantages and drawbacks, and covers the types of data to be used in databases to better understand and more effectively organize your databases.

(more…)

MySQL COUNT Function Examples

If your occupation has anything to do with databases, you face all kinds of routine tasks on data manipulation every day. Does it mean you have to do them all manually? Of course, not. It would consume all your time and raise plenty of risks. There are many convenient IDEs like dbForge Studio for MySQL with rich functionality letting you do the tasks automatically. No matter which tool you use, practical methods do exist, and they are well-known to database professionals. This article will explore one of the most frequently used functions in MySQL – the COUNT() function.

(more…)

GROUP BY Statement in MySQL With Twelve Examples

In this article, we’re going to share the MySQL tutorial how to use the MySQL GROUP BY function as well as this function usage together with and without aggregate functions.

(more…)

MySQL IF Statement and Function Explanation with Examples

There are two types of IFs in MySQL: the IF statement and the IF function. Both are different from each other. 

In this article, we will explain their diversities and show usage examples. Also, we will review other MySQL functions.

(more…)