MySQL BASIC COMMAND

1 come into mysql control:mysql -uname -ppassword;Enter

2 \h; show help

3 use databsename;change database

4 show databases;show all databases

   after selected db;entry show tables; view all tables' name

5 after use db;entry desc tablename;could show this table's structure(结构)

6 show variables like '%char%';view all character set

7 show variables like 'collation%';view mysql order(or collation);

8 show binlog events;show log-bin is work or not?

9 数据库备份，如果在path中配置了mysql-bin的变量，就直接在cmd中录入（否则需要运行到bin目录下再录）：

   mysqldump -uroot -proot dbname > d:\temp\0622.sql Enter