I've been using the original MySQL client for "eons" and I'm rather accustomed to using bash-like shortcuts in it. One of my more frequently used ones is to use control-w
to delete the word before the cursor (just like you do in bash).
Currently, with my mariadb client -- if I hit control-w
it deletes the entire line before the cursor. (which in bash at least is usually control-u
)
So for example, try it in a standard bash prompt.... or even in a classic MySQL command prompt, if I have a line like:
SELECT a,b,c FROM table WHERE column='value'
And I have my cursor before WHERE
the line will look like
WHERE column='value'
When I really expected it to be:
SELECT a,b,c FROM WHERE column='value'
I'm using Fedora, and the Maria version installed is:
[doug@talos werk]$ sudo rpm -qa | grep -i maria
mariadb-10.0.21-1.fc21.x86_64
mariadb-config-10.0.21-1.fc21.x86_64
mariadb-common-10.0.21-1.fc21.x86_64
Other shortcuts work as anticipated, control-a
and control-e
to go beginning and end of line respectively, and control-[left arrow]
moves a word left (or right with right arrow)
I'm running the client with:
mysql -A --host=foo.local -u user -p'mypass'
I can't find a reference to a maria client config options, like a .mariarc
or something. I'm happy to take any pointers.