Mysql client command line usage _ MySQL

The upper and lower keys of the mysql client command line can be used to repeat the preceding command line.
Show databases; display the database (do not forget the semicolon)
Create database test; create a test database (the default charset is utf8)
Create database test charset-gbk; create test database charset is gbk
Drop database test; delete the test database
Use test; select use test database
Show tables; displays the tables in the selected database
Charset GBK or utf8
You can directly write SQL statements to create tables.
Show create table users; you can view the users table structure and database engine (I am InnoDB) and character set charset = utf8;
Load data local infile 'd: // data // country.txt 'into table country (table name) fields terminated by '/t'; insert data in the txt file to the table