許多初學者混淆空字串 '' 與 NULL,導致查詢條件錯誤。本文透過生活化比喻、內存佔用、運算規則、左/右連接產生 NULL 等多角度釐清差異,並給出正確刪除語法。
IS NULL / IS NOT NULL 或 <=>。='' / <>'' 判斷。-- 錯誤
DELETE FROM t WHERE col = NULL;
-- 正確
DELETE FROM t WHERE col IS NULL;
-- 刪除空字串
DELETE FROM t WHERE col = '';
A(ID, Name) B(ID, Address)
1, Name1 1, Shanghai
2, Name2 3, Beijing
A LEFT JOIN B → 2, Name2, NULL
A RIGHT JOIN B → 3, NULL, Beijing
IS NULL / IS NOT NULL、IFNULL()。='' / <>''、IF(col, col, 0) (非 NULL 且非空才顯示)。NOT NULL 僅禁止插入 NULL,不影響空字串。