How can I have MySQL Workbench autocomplete with uppercase?
mysql-workbench
Solution
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".
Problem
By default, autocompletion is lowercase. Is there any way to have it uppercase?