Some commands are listed below here; you can use time to time to work with MySQL.
USE Databasename:
This command is usded for the select a database in the MySQL work area.
SHOW DATABASES:
This command is used for list out all the databased that are accessible by the MySQL root user.
SHOW TABLES:
This command is used for shows the tables in the database once a database has been selected with the use command.
SHOW COLUMNS FROM tablename:
This command is used for shows the attributes, types of attributes, key information, whether NULL is permitted, defaults, and other information for a table.
SHOW INDEX FROM tablename:
This command is used for displaypresents details of all indexes on the table, including the PRIMARY KEY.
SHOW TABLE STATUS LIKE tablename\G:
This command is used forshow reports details of the MySQL DBMS performance and statistics.
