Basic mysql command

mysql>

command to show all database:

 

• show schemas;

Command to choose one database:

• use <Database name>;

Command to show all existing tables in the chosen database:

• show tables;

Command to check the columns of a table:

• describe <tablename>; 

Command to show datas of a table:

• mysql>  select * from <table name>;