Useful MySQL Commands/Queries
mysqladmin ping
-This allows you to see if the mysql daemon is running
USE mysql;
-Typing this allows you to use the mysql database
SHOW TABLES FROM mysql;
-This allows you to see the schema of the database
SHOW COLUMNS FROM user;
-This allows you to see a detailed list of columns of your database
CREATE DATABASE db_name
CREATE DATABASE creates a database with the given name
DESCRIBE <tablename>
Shows columns from <tablename>
SHOW INDEX FROM <tablename>
Displays the current index information used in the nominated table
