null 与 unknown
来源:互联网 发布:淘宝助理怎么选类目 编辑:程序博客网 时间:2024/06/13 22:04
NULL indicates that the value is unknown. A null value is different from an empty or zero value.No two null values are equal. Comparisons between two null values, or between a null value and any other value, return unknown because the value of each NULL is unknown.
Null values generally indicate data that is unknown, not applicable, or to be added later. For example, a customer's middle initial may not be known at the time the customer places an order.
Note the following about null values:
To test for null values in a query, use IS NULL or IS NOT NULL in the WHERE clause.
Null values can be inserted into a column by explicitly stating NULL in an INSERT or UPDATE statement or by leaving a column out of an INSERT statement.
Null values cannot be used as information that is required to distinguish one row in a table from another row in a table, such as primary keys, or for information used to distribute rows, such as distribution keys.
When null values are present in data, logical and comparison operators can potentially return a third result of UNKNOWN instead of just TRUE or FALSE. This need for three-valued logic is a source of many application errors. These tables outline the effect of introducing null comparisons.
The following table shows the results of applying an AND operator to two Boolean operands where one operand returns NULL.
The following table shows the results of applying an OR operator to two Boolean operands where one operand returns NULL.
- null 与 unknown
- null 与 not null
- null与""
- null与“”
- null 与 ""
- mysql null与not null
- nil、null与ngx.null
- JSONObject null 与 "null" 判断
- CUICatalog: Invalid asset name supplied: (null)、Unknown CGRect
- mysql出现Unknown or incorrect time zone: 'NULL'
- CentOS挂载磁盘出错 mount: unknown filesystem type '(null)'
- SQL state [null]; error code [0]; 不支持从 UNKNOWN 到 UNKNOWN 的转换
- SQL state [null]; error code [0]; 不支持从 UNKNOWN 到 UNKNOWN 的转换
- Unknown
- unknown
- JAVA与SQL 中的null与NULL
- null与empty区别
- null与""的区别
- JVM概述
- 漫步最优化十五——凸函数优化
- POJ 3069 Saruman's Army 笔记
- 酷炫实现WebView与Native完美融合
- tensorflow学习系列(二):猫狗大战进阶
- null 与 unknown
- java中的HashTable,HashMap和HashSet
- SpringBoot框架集成开发
- 电子邮件加密技术初探(2017/07/18-2017/07/20探索日志)
- 数据结构与算法1-大话数据结构
- JavaScript实现几种常见的图形
- c语言字符串的详解
- CodeForces 725 F.Family Photos(贪心)
- HDU-1072-Nightmare