mysql不支持select into_mysql 不支持select into 只支持 insert into 以及替换字符串 replace...

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'