2

I am looking for free a Windows executable (not Java, Python, Ruby, etc...) Mysql command line/shell/console with autocomplete.

It should autocomplete keywords (sel<tab> becomes select, ins<tab> becomes insert, etc), table names and columns.

  • The column name autocomplete won't be able to function until you specify what table(s) you're selecting from in a FROM clause. – user151841 Jun 15 '16 at 13:59
  • Does it work in Windows? – Mawg Jun 15 '16 at 21:46
  • 1
    Actually, I just tested it in windows, and the column name will autocomplete when you prefix it with the table name. – user151841 Jun 16 '16 at 13:45
  • 1
    It does autocomplete table names; just not column names, unless you prefix them with the table name. E.g. if you have the table users and the field name, it won't autocomplete name; but it can autocomplete u[tab].n[tab]. And yes, it does autocomplete keywords. – user151841 Jun 28 '16 at 18:27
  • 1
    Sorry, I was referencing my answer, wherein one enables the mysql autocomplete. – user151841 Jun 28 '16 at 20:58
1

You can try MySQL-Workbench. It has auto-complete option, but is not command line. Learn more about it here

1

You can do this with two parts: Install cygwin with the mysql packages. This gives you the command line on windows. Then, enable the mysql autocomplete, either in a command line switch or in my.cnf.

  • While I would prefer not to install Cygwin just for this, it does seem a viable option, if I can find no altrernative, – Mawg Jun 29 '16 at 12:19
0

I just stumbled across this at work. I can't test it here, owing to the company firewall, but will test it at home & get back. It looks like it answers my requirements.

The Devart team has announced the new release of dbForge Studio for MySQL v 6.3 with new features related to SQL code completion and formatting, data import and export, data comparison, data synchronization, and reporting.

The list of new features includes Phrase Completion so that the Code Completion function suggests not only separate keywords and object names, but entire code phrases.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.