Vi in MySQL for command editing

Question

When using the MySQL command line interface, is there any way to get it to let you use vi command editing keys instead of emacs?

Answer 1

The MySQL command line interface uses readline to edit a command line.

Create a file ~/.inputrc with the following content to use vi mode:

$if mysql
set editing-mode vi
$endif

Of course, if you want to use vi mode in all applications (including e.g. bash) that use readline, you can leave out the $if & $endif ... lines...