文章来源:数据分析与统计学之美
作者:黄伟呢
1.测试数据
create table test_null (
id int,
name varchar(20),
chinese int,
math int,
english int
) charset=utf8;
insert into test_null
values
(1,null,80,70,68),
(2,'张三',60,null,null),
(3,'李四',null,90,80),
(4,'王五',90,60,75),
(5,null,null,50,95);
结果如下: