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?
Don't make mistakes. Especially in windows console.
Install a local copy of phpMyAdmin. It has more friendly means to execute a query.
For native clients, look here.