MySQL删除字段空字符串的行,以下两种都不行
DELETE FROM youmans_user WHERE avatar=‘’;
DELETE FROM youmans_user WHERE avatar=NULL;
这个亲测可用
```sql
DELETE FROM youmans_user WHERE avatar IS NULL;
MySQL删除字段空字符串的行,以下两种都不行
DELETE FROM youmans_user WHERE avatar=‘’;
DELETE FROM youmans_user WHERE avatar=NULL;
这个亲测可用
```sql
DELETE FROM youmans_user WHERE avatar IS NULL;