MySQL CREATE table when the empty value and non-null value setting what is the fastidious

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


------Solution--------------------
I generally try not to use null

If your 0 and null or ' and null have different meanings, then you need to allow empty
------Solution--------------------
This post was last edited by xuzuning on 2013-03-21 08:16:39

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

  • Related Article

    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.