mysql默认值？

Question

In my database, is it standard to leave most fields with default value "none"? For example a user id, a post title, category, or tags.

Answer 1

For required fields such as username or password, you should set NOT NULL. For other optional fields you can set it to NULL. For numbers, it is almost always a good idea to set default value to zero 0 .