MySQL 命令行客户端中的自动完成

在 Linux 和许多其他系统中，在导航终端时，可以按 Tab自动完成目录或文件名。

我想知道在 MySQL 终端中是否有类似的东西。例如，如果我想得到 someTableWithRidiculousLongName的描述，我可以键入 describe someTableW然后 Tab，它会自动完成其余的。

在 MySQL 终端中是否存在类似的东西？

49628 次浏览
小开

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
小开

To enable autocomplete within the MySQL prompt type:

mysql> \#

After that you can type:

mysql> describe someTableW[TAB]

To get:

mysql> describe someTableWithRidiculousLongName
小开

You can also auto-complete based on the command history. Start typing, then invoke the keys which are bound to ed-search-prev-history and ed-search-next-history. This applies if mysql comes with libedit support. The default keybindings are Ctrl-P and Ctrl-N, but this can be customized in .editrc. My example for Ctrl-up and Ctrl-down:

# start typing, then press Ctrl-Up
bind "\e[1;5A" ed-search-prev-history
# start typing, then press Ctrl-Up, then Ctrl-Down
bind "\e[1;5B" ed-search-next-history

Previously, mysql was based on readline, and then history-search-backward and history-search-forward are the correct commands. Configuration then was by means of .inputrc. Same example as above:

# these are the key bindings for the readline library
# start typing, then press Ctrl-Up
"\e[1;5A": history-search-backward
# start typing, then press Ctrl-Up, then Ctrl-Down
"\e[1;5B": history-search-forward

So, say you started typing sel and invoke Ctrl-Up, select * from some_long_table_name would come up if that is a command I have used earlier.

小开

Some notes about auto-rehash:

When you enable autocompletion editing the mysql config file..

[mysql]
auto-rehash

You can do it for all users or only for one user:

/etc/my.cnf: All Users

~/.my.cnf: Actual user

You can also disable autocompletion adding:

no-auto-rehash

Extracted from: http://www.sysadmit.com/2016/08/linux-mysql-autocompletar.html

小开

On OS X 10.11.6 I set --auto-rehash as described above, but it did not work. (This is OS X so mysql is compiled with the BSD libedit library.)

Then I remembered that I had set vi key-bindings for mysql client by creating ~/.editrc, containing one line: bind -v. This works great for giving me vi-like navigation in mysql client, but it broke column name completion (I was able to verify this by removing .editrc).

So I researched a little bit and found that ~/.editrc should have at least the following lines:

bind -v
bind \\t rl_complete

With this additional line, name completion works correctly in mysql AND vi-like navigation works also. (There are other .editrc settings which greatly improve mysql client navigation, but this isn't the place to start that thread of discussion.)

小开

I know this is an old question, but I've found very helpful MySql cli client with advanced autocompletion: mycli. It's much smarter than builtin auto-rehash feature.


提交答案