What’s New in dbForge Studio for MySQL, v6.1

Database connectivity support

  • MySQL 5.6
  • MySQL 5.7
  • MariaDB 5.5
  • MariaDB 10.0

MariaDB Virtual Columns are supported in:

  • Data Export/Import wizards
  • Data/Schema Comparison tools

Maria DB new features

  • SELECT (LIMIT ROWS EXAMINED) extended syntax
  • INSTALL SONAME new statement
  • SHOW EXPLAIN syntax
  • Multi-source replication syntax
  • Dynamic Columns syntax for DML statements
  • New KILL syntax
  • Expanded CREATE TABLE or ALTER TABLE syntax
  • New SHOW options are supported
  • Aria ENGINE
  • Virtual columns

New MySQL 5.6 new features

  • New ALTER TABLE … EXCHANGE PARTITION syntax constructions are supported
  • Microseconds in the TIME, DATETIME and TIMESTAMP data types are supported
  • New SELECT with partitioning syntax constructions are supported

MySQL 5.7 new features

  • New PRECEDES (CREATE TRIGGER) syntax constructions are supported
  • New spacial data types (DATA_GEOMETY) are supported
  • New GET DIAGNOSTIC syntax constructions are supported
  • New ALTER TABLE ALGORITHM=INPLACE syntax constructions are supported
  • New ALTER TABLE RENAME INDEX syntax constructions are supported

Microseconds support for TIME, DATETIME and TIMESTAMP data types

  • Data Editor
  • Data Export/Import wizards
  • Data Comparison tool

Pluggable authentication is supported

The product provides the extended support of pluggable authentication modules for MySQL servers.

Minor features and improvements

  • The application start time is decreased
  • Performance when worked with UI is improved
  • Federated and Aria engines are supported
  • All new clauses and statements are supported in Syntax Check
  • The FOLLOWS and PRECEDES clauses are supported in the Trigger editor
  • The ability to redo changes after undo in the table editor is added
  • Microsoft Windows 8.1 is supported

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?