常用命令
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)