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) tab);
-- 更改已经设置为企业的用户的权限组标识为17
update t_users set tpowergroupid=17 where id in (
select a.id from (
select tusers0_.id from t_users tusers0_, t_usersbasemessage tusersbase1_, t_useractioninfo tuseractio2_
where tusers0_.tusersbasemessageid=tusersbase1_.id and tusers0_.tuseractioninfoid=tuseractio2_.id and tusers0_.tuseractioninfoid=tuseractio2_.id and tusers0_.isenabled=0 and tusers0_.ischeck=0 and (tusers0_.tpowergroupid=4 or tusers0_.tpowergroupid=5) and tusersbase1_.typeid=614 and (tuseractio2_.recommendmark=1 or tuseractio2_.recommendmark=2) order by tuseractio2_.browsecount desc, tusers0_.createtime desc ) a
)
--601,606,608,607,617,613,614
这行sql语句会出现ERROR 1093错误
解决办法:
delete from myTableName where id in (select id from (select * from myTableName where colName is null) tab);
-- 更改已经设置为企业的用户的权限组标识为17
update t_users set tpowergroupid=17 where id in (
select a.id from (
select tusers0_.id from t_users tusers0_, t_usersbasemessage tusersbase1_, t_useractioninfo tuseractio2_
where tusers0_.tusersbasemessageid=tusersbase1_.id and tusers0_.tuseractioninfoid=tuseractio2_.id and tusers0_.tuseractioninfoid=tuseractio2_.id and tusers0_.isenabled=0 and tusers0_.ischeck=0 and (tusers0_.tpowergroupid=4 or tusers0_.tpowergroupid=5) and tusersbase1_.typeid=614 and (tuseractio2_.recommendmark=1 or tuseractio2_.recommendmark=2) order by tuseractio2_.browsecount desc, tusers0_.createtime desc ) a
)
--601,606,608,607,617,613,614