Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I have MySQL Workbench autocomplete with uppercase?

Tags:

By default, autocompletion is lowercase. Is there any way to have it uppercase?

enter image description here

like image 650
Franck Dernoncourt Avatar asked Jun 29 '13 19:06

Franck Dernoncourt


People also ask

How do I enable autocomplete in MySQL workbench?

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.

How do I get MySQL suggestions?

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 .

What is ZF in MySQL workbench?

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.


1 Answers

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".

enter image description here

like image 194
Franck Dernoncourt Avatar answered Sep 27 '22 21:09

Franck Dernoncourt