By default, autocompletion is lowercase. Is there any way to have it uppercase?
The SQL Editor offers autocomplete functionality by either pressing the keyboard shortcut (Modifier + Space), or it will start automatically if the Automatically Start Code Completion preference is enabled.
MySQL Shell supports autocompletion of text preceding the cursor by pressing the Tab key. The Section 3.1, “MySQL Shell Commands” can be autocompleted in any of the language modes. For example typing \con and pressing the Tab key autocompletes to \connect .
ZF is for Zero Filled. Suppose, we have declared int(3) and you want to store 21, then zero filled would output the result 021.
I submitted bug report:
Description: The autocompletion uses lowercase instead of uppercase, which is inconsistent with the SQL generated e.g. when altering a table, as well as with the ANSI standard http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt Demo: http://youtu.be/oRcjJcaej-M
How to repeat: In the SQL Editor, type "AL" then hit Ctrl+Space to trigger the auto completion. Demo: http://youtu.be/oRcjJcaej-M
Suggested fix: Use uppercase.
The issue is now solved:
Fixed as of the upcoming MySQL Workbench 6.0.4 release, and here's the changelog entry:
A new preference was added to toggle casing for the generated keywords in the auto completion list. "Edit", "Preferences", "SQL Editor TAB", "Use uppercase keyboards on completion".
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With