57,062
社区成员
发帖
与我相关
我的任务
分享BEGIN
select @biaos:=`data` from classm_t_propreties where
`key`='user.idgeneration.pp';
DELETE FROM classm_t_loginnablesafe where
classm_t_loginnablesafe.loginnableid=@urId;
if left(@urId,4)=(@biaos) then
DELETE FROM classm_t_classpeople where classm_t_classpeople.id=@urId;
ELSE DELETE FROM classm_t_adminusr where classm_t_adminusr.id=@urId;
end IF
END;