單項(xiàng)選擇題

在MYSQL數(shù)據(jù)庫中查詢某個(gè)字段不為空,下列哪個(gè)語法是正確的()

A.SELECT*FROM work WHERE info is notNULL
B.SELECT*FROM work WHERE info==NULL;
C.SELECT*FROM work WHERE info=NULL;
D.SELECT*FROM work WHERE infoISNULL;

微信掃碼免費(fèi)搜題