![]() ![]() Improve custom PSMTabBar implementation for improved appearance and dragging behaviour.Implement tabs for multiple connections within the same window.Made many more strings and interface components localisable.Add a “Provide Translation Feedback” menu item in the Help menu.Add translation support to the application including easy interface translation and a translation ecosystem.Add the ability to double-click in empty areas of main tableviews to add new rows.Right-align numeric columns in table content and custom query views.Improve the field editor sheet to be document-modal, and improve standard OS interaction within it - for example Find and undo behaviour.Move the “performance_schema” database to the system databases group.Add the ability to “Jump to Selection” (⌘J).Add the ability to move the selected line up or down in many text views (^⌘↑ and ^⌘↓).Support three-finger swiping gestures for navigating backwards and forwards in history.Improve the interface to more closely reflect the capabilities of different server versions.Improve support of the Escape key to cancel or abort row editing.Don’t allow input in the editor textfield or sheet if the field length would be exceeded.Display the field type and NULL details in the editor sheet.Reduce the minimum window size by making the connection view layout scrollable.When using Show/Copy Create Syntax on Procedures wrap the output with DELIMITER for convenience.Allow Show/Copy Create Syntax use when multiple items are selected, showing all create syntaxes.Support ^= as a keyboard shortcut to restore font sizes to their default setting in edit fields.Add a Sequel Pro Quicklook plugin, for SQL and connection/session files.Support dragging tables onto the table list to copy that table and its content.Support dragging and dropping tables and columns into custom query editors.Support synching the navigator selection to the current view.Support double-clicking databases and tables to switch the active window to the selection.Support selecting columns to view overview information about each.Display a filterable list of all databases, their tables, and their columns.Add a server Navigator view for viewing databases and tables:.Update Add Table and Add Database dialogs to use lists of supported encodings provided by the server.Improve the layout of several menus and rename a number of menu items for clarity.Implement database duplication, including content if requested.Filesystem sizes are now reported in base 2 (KiB/MiB) rather than base 10 (KB/MB) to clarify what 1GB represents.Made deletion actions more consistent by renaming many occurrences of “Remove” to “Delete”.Allow tab and shift-tab to select all cells - including BLOB content - opening the editor sheet on first edit. ![]() The enter key now ends editing for the current cell and saves the row.Support the up and down arrow keys to navigate between cells in Content and Query views.There are however many, many more features to discover some of the changes in this version are: This SQL keywords reference contains the reserved words in SQL.Highlights of the new features in this version are: translation support, plugin support, tabbed window support, QuickLook, new index creation interface, overhauled and unified export interface, improved import interface with much better CSV field mapping, a server navigator, improved data type support including spatial data support, improved table views and much improved stability. String Functions: ASCII CHAR_LENGTH CHARACTER_LENGTH CONCAT CONCAT_WS FIELD FIND_IN_SET FORMAT INSERT INSTR LCASE LEFT LENGTH LOCATE LOWER LPAD LTRIM MID POSITION REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SPACE STRCMP SUBSTR SUBSTRING SUBSTRING_INDEX TRIM UCASE UPPER Numeric Functions: ABS ACOS ASIN ATAN ATAN2 AVG CEIL CEILING COS COT COUNT DEGREES DIV EXP FLOOR GREATEST LEAST LN LOG LOG10 LOG2 MAX MIN MOD PI POW POWER RADIANS RAND ROUND SIGN SIN SQRT SUM TAN TRUNCATE Date Functions: ADDDATE ADDTIME CURDATE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME DATE DATEDIFF DATE_ADD DATE_FORMAT DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT FROM_DAYS HOUR LAST_DAY LOCALTIME LOCALTIMESTAMP MAKEDATE MAKETIME MICROSECOND MINUTE MONTH MONTHNAME NOW PERIOD_ADD PERIOD_DIFF QUARTER SECOND SEC_TO_TIME STR_TO_DATE SUBDATE SUBTIME SYSDATE TIME TIME_FORMAT TIME_TO_SEC TIMEDIFF TIMESTAMP TO_DAYS WEEK WEEKDAY WEEKOFYEAR YEAR YEARWEEK Advanced Functions: BIN BINARY CASE CAST COALESCE CONNECTION_ID CONV CONVERT CURRENT_USER DATABASE IF IFNULL ISNULL LAST_INSERT_ID NULLIF SESSION_USER SYSTEM_USER USER VERSION SQL Server Functions ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |