MySQL的status、describe命令

常用命令

1.查看数据库字符集状态（status）

mysql> status;
        --------------
        mysql  Ver 14.14 Distrib 5.7.33, for Win64 (x86_64)

        Connection id:          33
        Current database:       school
        Current user:           root@localhost
        SSL:                    Cipher in use is ECDHE-RSA-AES128-GCM-SHA256
        Using delimiter:        ;
        Server version:         5.7.33-log MySQL Community Server (GPL)
        Protocol version:       10
        Connection:             localhost via TCP/IP
        Server characterset:    latin1
        Db     characterset:    latin1
        Client characterset:    gbk
        Conn.  characterset:    gbk
        TCP port:               3306
        Uptime:                 8 hours 49 min 45 sec

        Threads: 1  Questions: 606  Slow queries: 0  Opens: 254  Flush tables: 1  Open tables: 226  Queries per second avg: 0.019
        -------------- 

2.查看特定表的详细设计信息（describe也可以用desc）

mysql> describe student;
        +----------+-------------+------+-----+---------+-------+
        | Field    | Type        | Null | Key | Default | Extra |
        +----------+-------------+------+-----+---------+-------+
        | Sname    | varchar(20) | YES  |     | NULL    |       |
        | Sex      | char(1)     | YES  |     | NULL    |       |
        | birthday | date        | YES  |     | NULL    |       |
        +----------+-------------+------+-----+---------+-------+
        3 rows in set (0.00 sec)