Actually, I am only looking for a single feature:

I would like to emulate the Bash shell's Ctrl-r in a MySql console.

That is to say, I type the first few characters of a previously issued command and Ctrl-r allows me to step back through all commands which began thus.

Any other bells & whistles are, of course, welcome.

  • 1
    From the specifications given, may I point out that the mysql command-line client does exactly that? :) – Izzy Mar 21 '15 at 15:19
  • Mine doesn't - not on Windows. I use the standard MySql install and while I can go backward through the command history using up arrow, I cannot search for commands beginning with a given text. Or, can I? How? – Mawg Mar 21 '15 at 17:32
  • 1
    Oh, Windows... Sorry, no idea (the only windows I have are for light and fresh air). I was assuming Bash → Linux... Well, my fault. You wrote "for Windows" and had the tag there. But now, it could still have been working on Windows as well – you didn't state having tried the CLI :) – Izzy Mar 22 '15 at 0:12
  • NVm, it was a good comment for a Saturday evening ;-) That's the frustration. Window has special terminal for MySql, but it is extremely basic :-( – Mawg Mar 22 '15 at 7:09
  • 1
    Seems to be the opposite combination to Oracle's sqlplus – which has all those features in the Windows version, but lacks them on *nix (not even basic readline support there). OK, I must pass here – but hopefully someone else knows about something. Good luck! – Izzy Mar 22 '15 at 10:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.