INSERT INTO sys_perm
SELECT id,NAME,url,num,ismenu,'ipace',CODE,pcode,pcodes,icon,levels,tips,STATUS,isopen FROM sys_menu
DELETE FROM sys_perm
SELECT*FROM sys_perm
UPDATE sys_perm SET isopen=2
UPDATE sys_perm SET ismenu=2 WHERE ismenu=0
UPDATE sys_perm SET pcodes= REPLACE(pcodes, ',', '|')
UPDATE sys_perm SET pcodes= REPLACE(pcodes, '[', '')
UPDATE sys_perm SET pcodes= REPLACE(pcodes, ']', '')
SELECT * FROM sys_role_perm
DELETE FROM sys_role_perm
INSERT INTO sys_role_perm
SELECT UUID(),'aaa',id,'ipace' FROM sys_perm
SELECT *FROM sys_perm
SELECT id,pcodes FROM sys_perm WHERE pcodes LIKE '%|role|%' AND tenant_id='ipace'