UPDATE BAS_ORGANIZATION_TYPE T1
SET T1.PARENTID=(select rn from (SELECT id,rownum rn FROM BAS_ORGANIZATION_TYPE T2 )awhere a.id=t1.parentid);update bas_organization_type set id=rownum;
本文共 236 字，大约阅读时间需要 1 分钟。
UPDATE BAS_ORGANIZATION_TYPE T1
SET T1.PARENTID=(select rn from (SELECT id,rownum rn FROM BAS_ORGANIZATION_TYPE T2 )awhere a.id=t1.parentid);update bas_organization_type set id=rownum;
转载于:https://www.cnblogs.com/kexb/p/5993607.html