MySQL commands I forget all the time

mysql_commands_i_always_forget.sql

-- Reset the query cache
RESET QUERY CACHE;

-- Closes all open tables, forces all tables in use to be closed, and flushes the query cache.
FLUSH TABLES;

-- Show character set in use by client, server, etc.
SHOW VARIABLES LIKE 'character_set%';