create table userinfo (num int not NULL,name varchar(20), age int , primary key(num));
INSERT INTO userinfo(num , name , age) VALUES (1 , 'yuhui' , 30);
INSERT INTO userinfo(num , name , age) VALUES (2 , '余辉' , 30);
INSERT INTO userinfo(num , name , age) VALUES (3 , NULL , 31);
INSERT INTO userinfo(num , name , age) VALUES (4 , '雷杰旭' , 28);
INSERT INTO userinfo(num , name , age) VALUES (5 , '李辉' , 35);
INSERT INTO userinfo(num , name , age) VALUES (6 , '李岳铸' , 35);
INSERT INTO userinfo(num , name , age) VALUES (7 , '潘玉芳' , 18);
INSERT INTO userinfo(num , name , age) VALUES (8 , NULL, 30);
1.userinfo 表
SELECT * from userinfo;
2.找到里面userinfo 是null的行
SELECT * from userinfo