mysql中的null知识点

mysql中的null知识点

#mysql中的null知识点

SELECT NULL = NULL;
SELECT NULL != NULL;
SELECT NULL <> NULL;

#字符串
SELECT 'NULL' = 'NULL';
SELECT 'NULL' != 'NULL';
SELECT 'NULL' <> 'NULL';
#
SELECT '令狐冲' = '令狐冲';
SELECT '令狐冲' != '令狐冲';
SELECT '令狐冲' <> '令狐冲';

SELECT 666 = 666;
SELECT 666 != 666;
SELECT 666 <> 666;

SELECT 666 != 888;
SELECT 666 <> 888;

#
CREATE TABLE temp03(
id INT,
name VARCHAR(20)
);
#
INSERT INTO temp03 VALUES(1, '韦小宝'),(2, '张无忌'),(3, NULL);
SELECT * FROM temp03;
SELECT * FROM temp03 WHERE name = '韦小宝';
SELECT * FROM temp03 WHERE name = NULL;#查询不到数据
SELECT * FROM temp03 WHERE name != NULL;#查询不到数据
SELECT * FROM temp03 WHERE name <> NULL;#查询不到数据

SELECT * FROM temp03 WHERE name IS NULL;#可以查询到数据
SELECT * FROM temp03 WHERE name IS NOT NULL;#可以查询到数据

#以下语句的结果都为NULL
SELECT NULL + 5;
SELECT NULL - 8;
SELECT NULL*2;
SELECT NULL/3;
SELECT NULL+NULL;