MySQL

I started working again with MySQL.  This past August I started a new job and MySQL is what the company uses for their db.  It has been five years since I last used it.  SQL has always intrigued me, there's always something new to learn about databases.  Here's are a few details that I've found handy-

• Redirecting query results to a file-
• select * from devices where device_id = 'abc' into outfile '/tmp/queryresults2010dec18.txt';

•  View db internals-
• show innodb status\G