错误写法:
SELECT PCODE,NAME FROM T_AREA WHERE PCODE = NULL;
正确写法:
SELECT PCODE,NAME FROM T_AREA WHERE PCODE IS NULL;
这里一定要用IS,不能再习惯性地用 = 了,谨记谨记!!!
错误写法:
SELECT PCODE,NAME FROM T_AREA WHERE PCODE = NULL;
正确写法:
SELECT PCODE,NAME FROM T_AREA WHERE PCODE IS NULL;
这里一定要用IS,不能再习惯性地用 = 了,谨记谨记!!!