MySql-語法練習2-查詢練習-欄位是否為Null

文、意如

查詢欄位為空的

SELECT * FROM grade WHERE english IS NULL;

 

查詢欄位不為空

SELECT * FROM grade WHERE english IS NOT NULL;

Yiru@Studio - 關於我 - 意如