空 vs Null
1:空值(”)是不占用空间的
2: MySQL中的NULL其实是占用空间的。官方文档说明:
https://blog.csdn.net/qq_29180565/article/details/90050510
索引使用
https://blog.csdn.net/Sunnyside_/article/details/116008281
字符集
utf8 vs utf8mb4
唯一索引:
https://stackoverflow.com/questions/9764120/does-a-unique-constraint-automatically-create-an-index-on-the-fields
left join
https://www.jianshu.com/p/a0c0a1ab49bf