liangzy 发表于 2018-8-10 16:46:41

整理的删除SQL,有些数据在界面无法删除

整理的删除SQL,有些数据在界面无法删除:

1.          删除一个人:

                delete from t_s_role_user
                where userid = '4028ef81563ae5be01563ae92d7f0002';

                delete from t_s_user
                where id = '4028ef81563ae5be01563ae92d7f0002';

                delete from t_s_base_user
                where id = '4028ef81563ae5be01563ae92d7f0002';
               
2.    删除一个组织机构
      deletefromt_s_user_orgwhere org_id='8a8ab0b246dc81120146dc8180a20016'
      delete from t_s_role_org where org_id='8a8ab0b246dc81120146dc8180a20016'               
          
          
3.   删除角色

   deletefrom t_s_role_user where roleid = '402880e74d75c4dd014d75d3c5f40001';

       delete from t_s_role_org where role_id = '402880e74d75c4dd014d75d3c5f40001';

       delete from t_s_role where id = '402880e74d75c4dd014d75d3c5f40001';          

sunonly 发表于 2018-8-25 09:57:54

总结得很好
页: [1]
查看完整版本: 整理的删除SQL,有些数据在界面无法删除