CODEWITHSUNDEEP
mysqlmysql-workbenchworkbench
user605334
user605334

Reputation:

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).

enter image description here

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?

Upvotes: 20

Views: 41839

Answers (4)

StackRover
StackRover

Reputation: 587

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.

Upvotes: 0

nkatsar
nkatsar

Reputation: 1660

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.

Upvotes: 7

José Mira
José Mira

Reputation: 751

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.

Upvotes: 5

Skrol29
Skrol29

Reputation: 5552

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

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

Upvotes: 19

Related Questions