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>;
好的心态+正确的方法