What is the relationship between mysql default and whether it is empty?

RT
By the way, I saw a blog saying this
If there is a default value, it is not allowed to be empty, otherwise it will be inconsistent. After the data is modified, it will still be its default value
At the same time, what I want to know is if I set the default value Then if the query is not set to be nullable, will the default be automatically filled in? What will be the consequences if it is set to be nullable? Of course, I am referring to the strict mode

Please come and save me

Reply content:

RT

By the way, I saw a blog saying this
If there is a default value, it is not allowed to be empty, otherwise it will be inconsistent. After the data is modified, it will still be its default value
At the same time, what I want to know is if I set the default value Then if the query is not set to be nullable, will the default be automatically filled in? What will be the consequences if it is set to be nullable? Of course, I am referring to the strict mode

Please come and save me

If you don’t want to, how about trying it yourself. You'll know the answer to some things just by trying them yourself.