=0 提示很明显了啊。类型不匹配。

DELETE FROM Course where Cpno IS NULL;

试试这两个呢？

update course set cpno='' where cno='2';

update course  set cpno=ifnull(cpno,'');

delete from t where t.col_name = '' or t.col_name is null or t.col_name = null;