mysql error 1093 解决方法

delete from myTableName where id in (select id from myTableName where colName  is  null);

这行sql语句会出现ERROR 1093错误

解决办法：

delete from myTableName where id in (select id from (select * from myTableName where colName is  null) tempTable);