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 Sqlyo开发者_运维技巧g does?
Auto-completion is not available yet, it's planned for MySQL Workbench version 6.
See http://wb.mysql.com/?p=229#comment-1250
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.
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.
I had similar issue where the mysql workbench intellisense worked, but did not show the column names. I followed the instructions in https://stackoverflow.com/a/37862473/1500224
It didn't work until I typed mydatabase
and hit a dot (select * from mydatabase.
) and suddenly it started working.
精彩评论