Does MySQL Workbench autocomplete work?

问题:

Using MySQL Workbench, when I press CTRL + space it looks like there is an autocomplete feature (However, no items appear in the auto complete box).

I am not sure that MySQL workbench has an autocomplete feature like SQLyog has(See screen-shot).

So if MySQL Workbench really has an intellisense or autocomplete like feature then how I can get them?

Is there any way to make MySQL Workbench auto complete the same way as Sqlyog does?

回答1:

Auto-completion is not available yet, it's planned for MySQL Workbench version 6.

See http://wb.mysql.com/?p=229#comment-1250

回答2:

It now does, as of yesterday (http://dev.mysql.com/doc/workbench/en/wb-news-5-2-41.html). Although it still only provides basic code completion.

回答3:

If the autocomplete feature does not suggest table or column names, try deleting the cache files of the specific connections from the MySQL Workbench cache located on:

• Windows: %AppData%\MySQL\Workbench\cache\
• OS X: ~username/Library/Application Support/MySQL/Workbench/cache/
• Linux: ~username/.mysql/workbench/cache/

More details about the configuration files can be found on https://dev.mysql.com/doc/workbench/en/wb-configuring-files.html

No matter the MySQL Workbench version (6.2.3, 6.2.5, 6.3.4), in my case the autocompletion was working but did not include table or column names.

After noticing that this happened only on some of the connections, I deleted the cache files and it started working again.