MySQL Workbench 自动完成功能是否有效？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5483304/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Does MySQL Workbench autocomplete work?
提问by Skrol29
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).
使用MySQL Workbench 时，当我按 CTRL + 空格时，它看起来有一个自动完成功能（但是，自动完成框中没有显示任何项目）。
I am not sure that MySQL workbench has an autocomplete feature like SQLyoghas(See screen-shot).
我不确定 MySQL 工作台是否具有像SQLyog那样的自动完成功能（参见屏幕截图）。
So if MySQL Workbench really has an intellisense or autocomplete like feature then how I can get them?
因此，如果 MySQL Workbench 真的具有智能感知或自动完成功能，那么我如何获得它们？
Is there any way to make MySQL Workbench auto complete the same way as Sqlyog does?
有没有办法让 MySQL Workbench 像 Sqlyog 一样自动完成？
回答by Skrol29
Auto-completion is not available yet, it's planned for MySQL Workbench version 6.
自动完成功能尚不可用，它计划用于 MySQL Workbench 版本 6。
回答by José Mira
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.
现在确实如此，截至昨天（http://dev.mysql.com/doc/workbench/en/wb-news-5-2-41.html）。虽然它仍然只提供基本的代码补全。
回答by nkatsar
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:
如果自动完成功能不建议表名或列名，请尝试从位于以下位置的 MySQL Workbench 缓存中删除特定连接的缓存文件：
- Windows: %AppData%\MySQL\Workbench\cache\
- OS X: ~username/Library/Application Support/MySQL/Workbench/cache/
- Linux: ~username/.mysql/workbench/cache/
- Windows：%AppData%\MySQL\Workbench\cache\
- OS X：~用户名/库/应用程序支持/MySQL/Workbench/cache/
- Linux：~用户名/.mysql/workbench/cache/
More details about the configuration files can be found on https://dev.mysql.com/doc/workbench/en/wb-configuring-files.html
有关配置文件的更多详细信息，请访问 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.
无论 MySQL Workbench 版本（6.2.3、6.2.5、6.3.4）如何，在我的情况下，自动完成功能都在工作，但不包括表名或列名。
After noticing that this happened only on some of the connections, I deleted the cache files and it started working again.
在注意到这仅发生在某些连接上之后，我删除了缓存文件并重新开始工作。
