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
Shows columns from
SHOW INDEX FROM
Displays the current index information used in the nominated table