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能跟着时区走

https://www.jianshu.com/p/08c4b78402ff

posted @ 2021-01-28 16:25  努力吧阿团  阅读(91)  评论(0)    收藏  举报