Searching binary columns in the Table Content view works as expected. Fixed visual issues in the Compare Databases settings window. After having changed the value of an editable column in the Query view, the row is updated to reflect that new value instead of maintaining the old value. After having changed the value of a non-writable column in the Query view, the previous (real) value is restored instead of looking like it was actually changed. The Database Content view's list of tables has updated column widths to account for changes on recent OS versions. SPATIAL indexes can now be created in the Table Indexes view. In Database Comparison, if the "Ignore definer" setting is turned on, the generated script will not have an definer clause for either CREATE or ALTER statements of views, functions, or procedures. When duplicating databases and tables, the SQL_MODE is explicitly set to a known state to avoid conflicts with ANSI_QUOTES. When importing CSV and SQL, the SQL_MODE is explicitly set to an initial known state to avoid conflicts with ANSI_QUOTES and NO_AUTO_VALUE_ON_ZERO. In the Query view, rows can now be deleted if they come from a single table and contain the table's primary key. The field-value editing panel can now be set in preferences to be either a popover or a modal sheet requiring explicit clicking of "Apply". You can also specify an index part being ASC or DESC. The Table Indexes view now allows typing in "functional key parts" (expressions) when supported by MySQL. There is a new Geometry editor in the field value editor window which will edit geometry columns as Well-Known Text. Geometry columns are selected in their native binary form and displayed either as hex or Well-Known Text, according to a new preference. (Interpreted with a specified text encoding.) 
Binary columns can be edited as plain Text in the field value editor window.The Database Comparison window now has a "Settings…" button which lets you go back and change comparison settings.
Hex and Binary literals (0x1234 / 0b0101) can be entered into binary columns directly in the Table Content results.Can set the "Selected Database" in the Query view back to "None".Table columns in the Table Structure view can be copied and pasted between different tables.Connections can now be made to remote Unix sockets through an SSH tunnel.Can drag saved queries to Finder to create SQL files.Can search for queries within the Saved Queries and Recent Queries list.(eg "SELECT * FROM myTable t WHERE t." shows myTable column names) Adds better autocomplete suggestions when using table aliases.Added File -> Settings -> Import/Export Settings, where you can select saved connections, queries, preferences, etc, to be exported into a single encrypted file for easily transferring all settings to a new machine (including connection passwords).
0 kommentar(er)
