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