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

Last modified: September 25, 2024

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