What is the value of the null and non-null settings when MySQL creates a table?

Source: Internet
Author: User
Tags null null
What is the value of the null and non-null settings when MySQL creates a table?


Reply to discussion (solution)

Did anyone answer????

I generally try not to use null

If your 0 and null or ' and null have different meanings, then you need to allow empty

It depends on your business needs.
Null null means nothing is entered, that is, the data item is invalid

If your business requires data items to have an initial value, then you should use NOT null (not empty) and set the initial value

The above is the empty value and non-null value setting when MySQL creates the table what is the focus of the content, more relevant content please pay attention to topic.alibabacloud.com (www.php.cn)!

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.