If you're on a unix-like machine, you might be able to just type edit at
the mysql> prompt, which might take you to a vi session, much better for
editing complex sql commands. When you want to execute the command, in vi
just do ZZ, which will take you back out to mysql client. Type go or \G t
Alright, this may come across as a stupid question -
In the mysql client, is there any way to get rid of the damn -> sign
when you are writing a query out?
I ask because it'd make it alot easier to copy and paste the query back
in, if lets say, I messed up on a single item.
mysql> create table
