How to go up a line to fix a mistake in command line? MySQL console

Question

I really looked hard and long and is there really no way to go up a line to fix a typo without having to type my query all over again?

I am using MySQL console on Windows 7.

If not, what should I be using to learn MySQL?

Answer 1

Using \e will allow you to edit the command by opening it up in text editor

edit      (\e) Edit command with $EDITOR.

http://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html