Autocompletion in the MySQL command-line client

To enable autocomplete within the MySQL prompt type:

mysql> \#

After that you can type:

mysql> describe someTableW[TAB]

To get:

mysql> describe someTableWithRidiculousLongName

start MySQL console with additional option --auto-rehash, i.e.

mysql --auto-rehash -u root -p

Edit or create a file called .my.cnf in your home directory, containing:

[mysql]
auto-rehash

Related