mysql清除内容是null或者是字符串null的数据

DELETE FROM table_name WHERE some_column=null

table_name替换为表名。

some_column替换为所要清楚数据的列。

删除还是替换

删除

delete from table where column is null

替换

update table

set column=''

where column is null

---