Mysql常用命令以及字符编码(未整理)
mysql> show processlist;
+----+------+-----------+------+---------+------+----------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+------+---------+------+----------+------------------+
| 3 | root | localhost | NULL | Query | 0 | starting | show processlist |
+----+------+-----------+------+---------+------+----------+------------------+
1 row in set (0.00 sec)
参考
https://www.cnblogs.com/flzs/p/11044689.html

恢复备份


查询mysql支持的字符集

5.7默认字符集是拉丁语latin1
utf8mb4 是常用的utf8编码
mysql8.0默认utf8mb4

mysql>show collation;支持的编码

后面有yes代表开启
100个字符长度占用空间大小跟字符集有关,utf8就只占用 300个字节
char比varchar查询效率要快,因为varchar每次都要计算长度,char是指定固定长度



timestamp能跟着时区走

今天的学习是为了以后的工作更加的轻松!

浙公网安备 33010602011771号