With SQLyog MySQL GUI 12.2.5, JSON comes to SQLyog. This is a new and major thing. Also, Foreign Key management with NDB tables was added and the user- filter was improved in the User Manager. Additionally, some non-critical GUI bugs were fixed.
Changes as compared to MySQL GUI 12.2.4 include:
* 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. In the BLOB-viewer we have added validation that
content is valid JSON. Also JSON-related keywords and functions
are recognized in syntax highlighting and autocomplete. Also
please see note at the bottom.
* SQLyog GUI now supports Foreign Key constraints between NDB tables for MySQL Cluster 7.3+.
* It is now possible to filter the users based on a string in the …