SQL解决表结构不同的数据同步方案

INSERT INTO uc_sys_resource (----需要同步的表 id, NAME, levels, parent_id, res, icon, location, application_id, sort_no, logic_delete ) SELECT id, NAME, parent_id, level AS levels, url, icon, type, project_code, sort, ENABLE FROM resources ---被迁移的表