Released: Jan 25, 2017

v12.4.0 での更新項目

Updates in v12.4.0

Features

• Added an option for defining a connection as ‘read-only’.  There is a checkbox in the connection settings and when checked the title bar will inform user about the ‘read-only’ state. In ‘read-only’ state statements that write cannot be executed.
• Added support for the MariaDB auth_gssapi (Kerberos) plugin. This plugin is available with the latest 3.0 (alpha) Connector/C from MariaDB. But there seems to  be a huge popular demand for this already, and Webyog has backported...

Released: Dec 26, 2016

v12.3.3 での更新項目

Updates in v12.3.3

Fixes

• Fixed an issue where Import External Data -jobs failed to authenticate SMTP.
• The sja.log would record syntax errors on recent servers if  Scheduled Backup was running with ‘Flush Master’ option. The generated backup file was OK. ‘Flush Master’ was deprecated in MySQL 5.6 and replaced with ‘Reset Master’. SQLyog now uses ‘Reset Master’ with such servers.
• In email settings of Import External Data wizard it was possible to leave the subject empty.
• When re-ordering columns...

Released: Nov 18, 2016

v12.3.2 での更新項目

Updates in v12.3.2

Fixes

• If an INIT_CONNECT setting in server configuration specified SET AUTOCOMMIT = 0 and global AUTOCOMMIT was 1 (or non-existent as in MySQL 4.1 and 5.0), the ‘transactions’ menu in SQLyog would incorrectly display AUTOCOMMIT as 1 after connection.
• Same code change as above also fixes a crash that could occur with 4.1 servers.
• Transactions support would fail to initialize with servers running global ANSI mode. SQLyog will not work in ANSI mode but connection and...

Released: Nov 16, 2016

v12.3.1 での更新項目

Updates in v12.3.1

Fixes

• 12.3.0 introduced a slowness when displaying the saved connections list with a large no. (100+) of saved connections. This is fixed now.
• Fixed a rare crash occurring sometimes when typing in the editor inside an invalid query longer than 128 characters. Auto-complete was at fault.

Released: Oct 26, 2016

v12.3.0 での更新項目

Updates in v12.3.0

Features

• GUI transactions support. This new feature is available in Enterprise and Ultimate editions. Also please see note below.
• Added a tooltip on column headers in Data tab informing about column name, column type and length. In Result tab the tooltip will display column name only, as the result returned by MySQL does not have information of storage type details.
• Added GUI support for index-level comments in CREATE/ALTER TABLE.

Fixes

• Fixed an issue where GUI could ‘hang’...

Released: Sep 12, 2016

v12.2.6 での更新項目

Updates in v12.2.6

Fixes

• SQLyog was not able to connect to RDS instances using SSL encryption. Attempting to do so returned the error “Failed to connect to MySQL: SSL connection error: certificate verify failed”.
• After having a connection open for very long time, SQLyog could crash when closing this connection.
• Corrupted connection information in the ‘session restore’-database could cause a crash. There was one reproducible report of this, but please note that there is no indication that SQLyog...

Released: Aug 19, 2016

v12.2.5 での更新項目

Updates in v12.2.5

Features:

• Added basic support for the JSON datatype as of MySQL 5.7.8+ and MySQL Cluster 7.5.2+. The datatype is now available in the CREATE/ALTER TABLE dialog and JSON data will open in the BLOB-viewer. The BLOB-viewer validates the content is valid JSON. Also JSON-related keywords and functions are recognized in syntax highlighting and autocomplete.
• SQLyog GUI now supports Foreign Key constraints between NDB tables for MySQL Cluster 7.3+.
• It is now possible to filter the...

Released: May 26, 2016

Updates in this release

Updates in 12.2.3

Features:

• User Manager filter: when some characters are typed for user in User Manager first match with same starting characters will be selected.

Bug Fixes:

• "Ignore Definer" did not work if "Drop Table if exist" and "Ignore Definer" both were ticked in cases where only procedures and/or functions were copied to another database.
• The result of a multiline string in text mode displayed empty in case where the string started with a line break.
• For "wide" BIT(n) types "0"-bits...

Released: May 5, 2016

Updates in this release

Updates in 12.2.2

Features:

• The 'date picker' now has a GUI control to insert current date.
• When running multiple statements in the editor and an error occured, SQLyog would continue to next statement. There is now an option to 'halt on error' in such cases.

Bug Fixes:

• The 'sys' database of MySQL 5.7 was erroneously backed up when choosing 'all databases' in the Scheduled Backup tool.
• Table-level comments were truncated at 490 characters.
• The 'date picker' calender could display distorted in...