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
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
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
Other shortcuts work as anticipated,
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.