Commands like SHOW DATABASES and SHOW TABLES are great but what if I need all the columns inside a table?

SELECT column_name FROM information_schema.columns WHERE table_schema = 'your_db' ORDER BY table_name, ordinal_position;

Source: http://stackoverflow.com/questions/5648420/get-all-columns-from-all-mysql-tables