• phone number is not known @w@ have no phone, and thus no phone number


    http://dev.mysql.com/doc/refman/5.7/en/problems-with-null.html

    B.5.4.3 Problems with NULL Values

    The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that NULL is the same thing as an empty string ''. This is not the case. For example, the following statements are completely different:

    mysql> INSERT INTO my_table (phone) VALUES (NULL);
    mysql> INSERT INTO my_table (phone) VALUES ('');
    

    Both statements insert a value into the phone column, but the first inserts a NULL value and the second inserts an empty string. The meaning of the first can be regarded as phone number is not known” and the meaning of the second can be regarded as the person is known to have no phone, and thus no phone number.”

    http://dev.mysql.com/doc/refman/5.7/en/working-with-null.html

    NULL means a missing unknown value”.

  • 相关阅读:
    JDBC
    「题解」:串串香
    「题解」:树
    「题解」:最近公共祖先
    「题解」:集合论
    「题解」:位运算
    「题解」:序列
    「总结」浅谈主席树
    $My$ $template$(持续更新)
    「题解」:毛三琛
  • 原文地址:https://www.cnblogs.com/rsapaper/p/6098522.html
Copyright © 2020-2023  润新知