In mysql optimization, the field setting is not null.
Craile2020-04-05 10:27:28
0
3
1317
In mysql optimization, try to avoid setting fields to null, which will affect the query speed. This refers to only whether the index field is not set to null, or it is best not to set all fields to null
replyTeacher, in your tutorial on PhpSpreadsheet for quickly controlling Excel with PHP, there is a 100php public method library. Can you send it to us? If you see the information, can you send it to my email (88303059@qq.com) Thank you
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
For the string type, just use EMPTY STRING as the default value. If you don’t use null, the problem you mentioned will not occur.
In the MyISAM engine of Mysql, the null value occupies additional storage space. (1bit), the empty string takes up no space at all.
Null values cannot be stored in B-tree indexes, which will cause serious performance problems when the amount of data is large