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);
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);