MySQL command line Shortcuts

\? = help 
\c = clear command
\C = switch to another charset (might be needed for processing multi-byte charsets)
\d = set delimiter (use something else after a statement instead of ;)
\g = send command to server
\G = send command to server
With \g and \G you can generate "vertical" output with each column value on a separate line. This makes large outputs far more readable !
\h = help
\p = print current command
\q = quit MySQL
\r = reconnect (or see which database you're in)
\R = change your mysql prompt (personalize your prompt, which can be funny)
\s = show status (which can be very informative)
\t = don't write to into outfile
\T = write into outfile
\u = use database
\w = don't show warnings after every statement
\W = show warnings after every statement
\# = rebuild completion hash
\. = execute an SQL scriptfile