studio for mysql

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

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

Data Types in MySQL: Tutorial and Full List with Examples of Data Formats

In the article, we are going to discuss data types including string, numeric, date and time, spatial, and JSON supported by MySQL. Also, we’ll provide examples of their usage and see how to change a data type for the table column using dbForge Studio for MySQL.

(more…)

New Shiny Badges on dbForge Studios’ Award Wall

The accolades for our dbForge Studios just keep coming!  Today we are immensely proud to announce that we received an array of major awards from the Crozdesk platform.

(more…)

How to Connect to MySQL Server Databases Remotely

Distributed environment is hardly a new notion in the world of software. For one, you no longer need to host MySQL servers and databases on the same local machine. Now you can have a dedicated server that can deliver the required level of security and performance. With the help of root/sudo user privileges, you can enable new remote connections and set up secure and effective teamwork with your databases using a remote MySQL server.

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

MySQL Primary Key: CREATE and ALTER TABLE Statements

Following the best practices of RDBMS involves the consistent usage of Primary Keys when designing databases to create and enforce Referential Integrity which is a major requirement for Data Quality and proper relational database design. In this tutorial, we provide background information on Primary Keys and their function as well as give code examples to illustrate the theory.

(more…)

Data Export from Amazon RDS MySQL Instance

The necessity to export data from Amazon RDS to the on-premises MySQL database may be spawned by various reasons such as a user request, an upgrade to a system, data consolidation, need for backup, etc. The fact that data are usually required yesterday and export tasks need to be repeated again and again only compounds the difficulty. This article presents a walkthrough on how to export data quickly and easily with the help of dbForge Studio for MySQL.

(more…)

How to Convert MySQL Data to PostgreSQL

Transferring data between two different servers is not an easy task as it requires a great deal of effort and accuracy, especially when migrating from one database management system to another. In this article, we provide a visual walkthrough of MySQL data migration to PostgreSQL Server.

(more…)