mysql - 如何删除多个空字段

Question

我正在尝试删除所有具有空值的字段，但我没有得到它，我尝试过这种方式但它不起作用。 DELETE FROM ctuser WHERE (SELECT *FROM ctuser WHERE nome = '');

标签： mysqlmysql-workbenchmysql-error-1064

Answer 1

试试这个： DELETE FROM ctuser WHERE nome = '' OR nome IS NULL;