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.

Improve this question
7
  • 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
    Commented Jun 15, 2016 at 13:59
  • Does it work in Windows?
    – Mawg
    Commented Jun 15, 2016 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
    Commented Jun 16, 2016 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
    Commented Jun 28, 2016 at 18:27
  • 1
    Sorry, I was referencing my answer, wherein one enables the mysql autocomplete.
    – user151841
    Commented Jun 28, 2016 at 20:58

3 Answers 3

Reset to default
1

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

Improve this answer
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.

Improve this answer
1
  • While I would prefer not to install Cygwin just for this, it does seem a viable option, if I can find no altrernative,
    – Mawg
    Commented Jun 29, 2016 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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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