Getting a list of stored procedures out of MySQL

Ick!

select SPECIFIC_NAME from information_schema.routines;

Sheesh!

MySQL command-line pager

msql has support for altering the pager's behavior. Current favorite found by a friend:

msql > pager less -n -i -S -F -X

This allows you to view "wide" tables... as tables! Vim navigation is available, as are the arrow keys. Try hitting the right arrow key. Come back when you're done. I'll wait here...

I know, right? You're welcome!