mysql 里面的isnull()和ifnull() is null 和 is not null

xiaoxiao2021-02-28  87

usergrade表

2.找到里面username是null的行

SELECT * FROM usergrade WHERE ISNULL(USERNAME)

SELECT * FROM usergrade  WHERE USERNAME IS NULL

3.找到里面username不是null的行

SELECT * FROM usergrade  WHERE USERNAME IS NOT NULL

4.列出所有的行,并且将username是null的字段替换为lxy

SELECT IFNULL(USERNAME,'lxy'),GRADE FROM usergrade 

转载请注明原文地址: https://www.6miu.com/read-69377.html

最新回复(0)