NULL 值表示 “无数据。” NULL 可以用任意字母大小写书写。The NULL value means “no data.”
NULL can be written in any lettercase.
请注意,NULL 值不同于数值类型的 0 或字符串类型的空字符串等值。有关更多信息,请参见 B.3.4.3 节,“关于 NULL 值的问题”。Be aware that the NULL value is different
from values such as 0 for numeric types or
the empty string for string types. For more information, see
Section B.3.4.3, “Problems with NULL Values”.
对于使用 LOAD DATA 或 SELECT ... INTO
OUTFILE 执行的文本文件导入或导出操作,NULL 用 \N 序列表示。请参见 第 15.2.9 节,“LOAD DATA 语句”。For text file import or export operations performed with
LOAD DATA or
SELECT ... INTO
OUTFILE, NULL is represented by the
\N sequence. See Section 15.2.9, “LOAD DATA Statement”.
对于使用 ORDER BY 的排序,NULL 值在升序排序时排在其他值之前,在降序排序时排在其他值之后。For sorting with ORDER BY,
NULL values sort before other values for
ascending sorts, after other values for descending sorts.