How do I enable auto completion feature so that SQL Workbench/J automatically completes the code. For example, If I alias a table in query then using that alias with a period should show the columns present in table.

SELECT * FROM EMPLOYEE E
WHERE E.

CodePudding user response：

First of all, I prefer using MySQL Workbench, but here is how you can turn auto-complete in SQL Workbench/J, here you will use the combination of some options to do this takse,

First, in your Menu Bar -> SQL:

SQL -> Settings -> 
1- Check: Auto Advance to next
2- Check: Detect prepared statements

Second, in your Menu Bar -> Tools:

Tools -> Options ->
1- Check: Close completion with search
2- check: QuickSearch matches anywhere

Finally, you can Ctrl Space and you will see the magic auto-completion I will provide some screenshots of mine, also you can check out the manual at

CodePudding user response：

Preferences screen

In Preferences: SQL Editor: Query Editor

Check Enable Code Completion in Editors and Automatically Start Code Completion

CodePudding user response：

I was able to find this option under SQL > Auto Completion

Default shortcut for MAC is CTRL SPACE

https://imgur.com/jOKK6bp